APPS.AZW_PROC dependencies on APP_EXCEPTION

Line 68: WHEN app_exception.application_exception THEN

64: EXCEPTION
65: WHEN NO_DATA_FOUND THEN
66: v_parent_gr_id := 'NONE';
67: RETURN v_parent_gr_id;
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');

Line 77: APP_EXCEPTION.RAISE_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:
81: --

Line 103: WHEN app_exception.application_exception THEN

99: v_ctx_id := SUBSTR(node_id, v_first_step + 1, v_second_step - v_first_step - 1);
100:
101: RETURN v_ctx_id;
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);

Line 111: APP_EXCEPTION.RAISE_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:
115: --

Line 143: WHEN app_exception.application_exception THEN

139: RETURN FALSE;
140: END IF;
141:
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);

Line 151: APP_EXCEPTION.RAISE_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:
155: --

Line 197: WHEN app_exception.application_exception THEN

193: RETURN v_id;
194: END IF;
195:
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);

Line 198: APP_EXCEPTION.RAISE_EXCEPTION;

194: END IF;
195:
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);

Line 205: APP_EXCEPTION.RAISE_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:
209: --

Line 228: WHEN app_exception.application_exception THEN

224: v_type := SUBSTR(node_id, 1, v_first_sep - 1);
225: RETURN v_type;
226:
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);

Line 236: APP_EXCEPTION.RAISE_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:
240: --

Line 262: WHEN app_exception.application_exception THEN

258:
259: RETURN p_name;
260:
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);

Line 263: APP_EXCEPTION.RAISE_EXCEPTION;

259: RETURN p_name;
260:
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);

Line 270: APP_EXCEPTION.RAISE_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: --
274: -- PARSE_PROCESS_NAME_TASK

Line 294: WHEN app_exception.application_exception THEN

290: p_name := SUBSTR(node_id, v_first_sep + 1, v_second_sep - v_first_sep - 1);
291: RETURN p_name;
292:
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);

Line 295: APP_EXCEPTION.RAISE_EXCEPTION;

291: RETURN p_name;
292:
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);

Line 302: APP_EXCEPTION.RAISE_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: --
306: -- PARSE_CONTEXT_ID

Line 326: WHEN app_exception.application_exception THEN

322: v_ctx_id := SUBSTR(node_id, v_last_sep + 1, v_len - v_last_sep);
323: RETURN v_ctx_id;
324:
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);

Line 327: APP_EXCEPTION.RAISE_EXCEPTION;

323: RETURN v_ctx_id;
324:
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);

Line 334: APP_EXCEPTION.RAISE_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:
338: --

Line 360: WHEN app_exception.application_exception THEN

356:
357: RETURN itm_k;
358:
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);

Line 368: APP_EXCEPTION.RAISE_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:
372: --

Line 410: APP_EXCEPTION.RAISE_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;
414:

Line 436: APP_EXCEPTION.RAISE_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
440: APP_EXCEPTION.RAISE_EXCEPTION;

Line 439: WHEN app_exception.application_exception THEN

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

Line 440: APP_EXCEPTION.RAISE_EXCEPTION;

436: APP_EXCEPTION.RAISE_EXCEPTION;
437: END;
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);

Line 447: APP_EXCEPTION.RAISE_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: --
451: -- get_context_name

Line 475: APP_EXCEPTION.RAISE_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: --
479: -- get_context_type

Line 518: APP_EXCEPTION.RAISE_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:
522: -- get_opm_context_name

Line 569: APP_EXCEPTION.RAISE_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:
573: --

Line 601: APP_EXCEPTION.RAISE_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
605: BEGIN

Line 619: APP_EXCEPTION.RAISE_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
623: BEGIN

Line 637: APP_EXCEPTION.RAISE_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
641: BEGIN

Line 652: APP_EXCEPTION.RAISE_EXCEPTION;

648: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
649: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
650: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_name');
651: fnd_message.set_token('AZW_ERROR_STMT','select name from gl_sets_of_books');
652: APP_EXCEPTION.RAISE_EXCEPTION;
653: END;
654:
655: ELSIF (ctx_type = 'OPMCOM' OR ctx_type = 'OPMORG') THEN
656: BEGIN

Line 665: APP_EXCEPTION.RAISE_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;
669:

Line 677: WHEN app_exception.application_exception THEN

673:
674: RETURN v_ctxt_name;
675:
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);

Line 685: APP_EXCEPTION.RAISE_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:
689: --

Line 713: WHEN app_exception.application_exception THEN

709: EXCEPTION
710: WHEN NO_DATA_FOUND THEN
711: v_application_name := 'NONE';
712: RETURN v_application_name;
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');

Line 714: APP_EXCEPTION.RAISE_EXCEPTION;

710: WHEN NO_DATA_FOUND THEN
711: v_application_name := 'NONE';
712: RETURN v_application_name;
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);

Line 722: APP_EXCEPTION.RAISE_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:
726: --

Line 748: WHEN app_exception.application_exception THEN

744:
745: RETURN v_meaning;
746:
747: EXCEPTION
748: WHEN app_exception.application_exception THEN
749: APP_EXCEPTION.RAISE_EXCEPTION;
750: WHEN NO_DATA_FOUND THEN
751: v_meaning := 'NONE';
752: RETURN v_meaning;

Line 749: APP_EXCEPTION.RAISE_EXCEPTION;

745: RETURN v_meaning;
746:
747: EXCEPTION
748: WHEN app_exception.application_exception THEN
749: APP_EXCEPTION.RAISE_EXCEPTION;
750: WHEN NO_DATA_FOUND THEN
751: v_meaning := 'NONE';
752: RETURN v_meaning;
753: WHEN OTHERS THEN

Line 760: APP_EXCEPTION.RAISE_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:
764: --

Line 782: WHEN app_exception.application_exception THEN

778: from fnd_languages
779: where NLS_LANGUAGE =
780: SUBSTR(USERENV('LANGUAGE'), 1, INSTR(USERENV('LANGUAGE'), '_')-1);
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);

Line 792: APP_EXCEPTION.RAISE_EXCEPTION;

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;
795: BEGIN
796: SELECT substr(text, 1, 8)

Line 809: APP_EXCEPTION.RAISE_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
813: SELECT substr(text, 1, 8)

Line 826: APP_EXCEPTION.RAISE_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
830: SELECT substr(text, 1, 8)

Line 843: APP_EXCEPTION.RAISE_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;
847:

Line 914: APP_EXCEPTION.RAISE_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
918:

Line 934: APP_EXCEPTION.RAISE_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
938:

Line 954: APP_EXCEPTION.RAISE_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
958:

Line 974: APP_EXCEPTION.RAISE_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
978:

Line 1027: APP_EXCEPTION.RAISE_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;
1031:

Line 1033: WHEN app_exception.application_exception THEN

1029:
1030: END IF;
1031:
1032: 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');

Line 1042: APP_EXCEPTION.RAISE_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:
1046:

Line 1084: APP_EXCEPTION.RAISE_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:
1088: --

Line 1125: APP_EXCEPTION.RAISE_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
1129: BEGIN

Line 1143: APP_EXCEPTION.RAISE_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;
1147:

Line 1149: WHEN app_exception.application_exception THEN

1145: END IF;
1146: END LOOP;
1147:
1148: 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');

Line 1158: APP_EXCEPTION.RAISE_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:
1162:

Line 1192: APP_EXCEPTION.RAISE_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;
1196: group_status_tbl( group_status_index ).item_type := proc.item_type;

Line 1203: WHEN app_exception.application_exception THEN

1199:
1200: END IF;
1201:
1202: 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');

Line 1212: APP_EXCEPTION.RAISE_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:
1216:

Line 1260: APP_EXCEPTION.RAISE_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: --
1264: -- disable_invalid_opm_processes

Line 1303: APP_EXCEPTION.RAISE_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:
1307: --

Line 1397: APP_EXCEPTION.RAISE_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
1401: BEGIN

Line 1423: APP_EXCEPTION.RAISE_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
1427: FOR invalid_process IN invalid_io_processes_cursor LOOP

Line 1448: APP_EXCEPTION.RAISE_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
1452: FOR invalid_process IN invalid_ou_processes_cursor LOOP

Line 1473: APP_EXCEPTION.RAISE_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;
1477:

Line 1479: WHEN app_exception.application_exception THEN

1475:
1476: END IF;
1477:
1478: 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');

Line 1488: APP_EXCEPTION.RAISE_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:
1492: END disable_invalid_processes;

Line 1532: APP_EXCEPTION.RAISE_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);
1536: get_context('OU', ou_ctx);

Line 1573: WHEN app_exception.application_exception THEN

1569: group_status_tbl(i).context_id);
1570: END LOOP;
1571:
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);

Line 1581: APP_EXCEPTION.RAISE_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:
1585:

Line 1653: APP_EXCEPTION.RAISE_EXCEPTION;

1649: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1650: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1651: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_process_comments');
1652: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1653: APP_EXCEPTION.RAISE_EXCEPTION;
1654: END;
1655:
1656: EXCEPTION
1657: WHEN app_exception.application_exception THEN

Line 1657: WHEN app_exception.application_exception THEN

1653: APP_EXCEPTION.RAISE_EXCEPTION;
1654: END;
1655:
1656: EXCEPTION
1657: WHEN app_exception.application_exception THEN
1658: APP_EXCEPTION.RAISE_EXCEPTION;
1659: WHEN OTHERS THEN
1660: -- DBMS_OUTPUT.PUT_LINE('error: update_process_comments: ' || SQLERRM);
1661: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

Line 1658: APP_EXCEPTION.RAISE_EXCEPTION;

1654: END;
1655:
1656: EXCEPTION
1657: WHEN app_exception.application_exception THEN
1658: APP_EXCEPTION.RAISE_EXCEPTION;
1659: WHEN OTHERS THEN
1660: -- DBMS_OUTPUT.PUT_LINE('error: update_process_comments: ' || SQLERRM);
1661: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1662: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

Line 1666: APP_EXCEPTION.RAISE_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:
1670: --

Line 1701: APP_EXCEPTION.RAISE_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
1705:

Line 1719: APP_EXCEPTION.RAISE_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
1723: SELECT COUNT(*)

Line 1736: APP_EXCEPTION.RAISE_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
1740: BEGIN

Line 1753: APP_EXCEPTION.RAISE_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
1757: SELECT ag.hierarchy_parent_id

Line 1769: APP_EXCEPTION.RAISE_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
1773: WHILE (v_parent_id IS NOT NULL) LOOP

Line 1788: APP_EXCEPTION.RAISE_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
1792: SELECT ag.hierarchy_parent_id

Line 1804: APP_EXCEPTION.RAISE_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:
1808: END IF;

Line 1813: WHEN app_exception.application_exception THEN

1809:
1810: END LOOP;
1811:
1812: 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');

Line 1822: APP_EXCEPTION.RAISE_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:
1826:

Line 1860: APP_EXCEPTION.RAISE_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
1864: NULL;

Line 1880: APP_EXCEPTION.RAISE_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
1884: v_status := 'Y';

Line 1902: APP_EXCEPTION.RAISE_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
1906: update_groups_status(v_group_id);

Line 1911: WHEN app_exception.application_exception THEN

1907:
1908: END IF;
1909:
1910: 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');

Line 1920: APP_EXCEPTION.RAISE_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:
1924: --

Line 1958: APP_EXCEPTION.RAISE_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
1962: BEGIN

Line 1976: APP_EXCEPTION.RAISE_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
1980: BEGIN

Line 1994: APP_EXCEPTION.RAISE_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
1998: UPDATE az_processes ap

Line 2010: APP_EXCEPTION.RAISE_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;
2014: -- update status for all ancestors

Line 2018: WHEN app_exception.application_exception THEN

2014: -- update status for all ancestors
2015: update_hierarchy_status(p_type, p_name, ctx_id);
2016:
2017: 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');

Line 2019: APP_EXCEPTION.RAISE_EXCEPTION;

2015: update_hierarchy_status(p_type, p_name, ctx_id);
2016:
2017: 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);

Line 2027: APP_EXCEPTION.RAISE_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:
2031: --

Line 2076: WHEN app_exception.application_exception THEN

2072: wf_engine.SetItemAttrNumber(p_itemtype, itemkey,
2073: 'AZW_IA_COA_ID', p_coa_id);
2074: end if;
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);

Line 2077: APP_EXCEPTION.RAISE_EXCEPTION;

2073: 'AZW_IA_COA_ID', p_coa_id);
2074: end if;
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);

Line 2084: APP_EXCEPTION.RAISE_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
2088: if(p_context is null) then

Line 2105: WHEN app_exception.application_exception THEN

2101: AZW_UTIL.UpdateDocUrl(p_itemtype, p_workflow);
2102:
2103: wf_engine.StartProcess(p_itemtype, itemkey);
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);

Line 2106: APP_EXCEPTION.RAISE_EXCEPTION;

2102:
2103: wf_engine.StartProcess(p_itemtype, itemkey);
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);

Line 2113: APP_EXCEPTION.RAISE_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:
2117: commit;

Line 2120: WHEN app_exception.application_exception THEN

2116:
2117: commit;
2118: v_new_task_key := itemkey;
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);

Line 2121: APP_EXCEPTION.RAISE_EXCEPTION;

2117: commit;
2118: v_new_task_key := itemkey;
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);

Line 2128: APP_EXCEPTION.RAISE_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:
2132:

Line 2246: WHEN app_exception.application_exception THEN

2242:
2243: RETURN v_label;
2244:
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);

Line 2254: APP_EXCEPTION.RAISE_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:
2258: --

Line 2317: WHEN app_exception.application_exception THEN

2313: CLOSE az_task_display_cursor;
2314: RETURN v_mesg;
2315:
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);

Line 2325: APP_EXCEPTION.RAISE_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:
2329: --

Line 2371: APP_EXCEPTION.RAISE_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,
2375: coa_id, ctx_id);

Line 2382: WHEN app_exception.application_exception THEN

2378: update_process_status(node_id, 'A');
2379: COMMIT;
2380: RETURN msg;
2381: 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');

Line 2383: APP_EXCEPTION.RAISE_EXCEPTION;

2379: COMMIT;
2380: RETURN msg;
2381: 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);

Line 2391: APP_EXCEPTION.RAISE_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:
2395: --

Line 2419: WHEN app_exception.application_exception THEN

2415: label := get_old_task_label(v_type, v_key, p_name, p_role);
2416: return label;
2417:
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);

Line 2420: APP_EXCEPTION.RAISE_EXCEPTION;

2416: return label;
2417:
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);

Line 2427: APP_EXCEPTION.RAISE_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:
2431: --

Line 2459: WHEN app_exception.application_exception THEN

2455: commit;
2456: return label;
2457:
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);

Line 2460: APP_EXCEPTION.RAISE_EXCEPTION;

2456: return label;
2457:
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);

Line 2467: APP_EXCEPTION.RAISE_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:
2471: --

Line 2495: WHEN app_exception.application_exception THEN

2491: label := get_old_task_label(v_type, v_key, p_name, p_role);
2492:
2493: RETURN label;
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);

Line 2496: APP_EXCEPTION.RAISE_EXCEPTION;

2492:
2493: RETURN label;
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);

Line 2503: APP_EXCEPTION.RAISE_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:
2507: --

Line 2552: WHEN app_exception.application_exception THEN

2548: RETURN 'Y';
2549: END IF;
2550: CLOSE az_task_status_cursor;
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);

Line 2553: APP_EXCEPTION.RAISE_EXCEPTION;

2549: END IF;
2550: CLOSE az_task_status_cursor;
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);

Line 2560: APP_EXCEPTION.RAISE_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:
2564: --

Line 2616: APP_EXCEPTION.RAISE_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
2620: -- Update all 'Complete' processes

Line 2632: APP_EXCEPTION.RAISE_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
2636: -- Update all 'Not Started' Processes

Line 2648: APP_EXCEPTION.RAISE_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;
2652:

Line 2654: WHEN app_exception.application_exception THEN

2650:
2651: COMMIT;
2652:
2653: EXCEPTION
2654: WHEN app_exception.application_exception THEN
2655: RAISE;
2656: WHEN OTHERS THEN
2657: -- DBMS_OUTPUT.PUT_LINE('error: populate_process_status: ' || SQLERRM);
2658: ROLLBACK;

Line 2664: APP_EXCEPTION.RAISE_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:
2668: --

Line 2707: APP_EXCEPTION.RAISE_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:
2711: --

Line 2758: APP_EXCEPTION.RAISE_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:
2762: END AZW_PROC;