APPS.AZW_PROC dependencies on AZW_PROC

Line 1: PACKAGE BODY AZW_PROC AS

1: PACKAGE BODY AZW_PROC AS
2: /* $Header: AZWPROCB.pls 115.46 2003/04/08 08:50:04 sbandi ship $: */
3:
4:
5: TYPE status_rec_t IS RECORD (

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 2762: END AZW_PROC;

2758: APP_EXCEPTION.RAISE_EXCEPTION;
2759: END process_has_active_tasks;
2760:
2761:
2762: END AZW_PROC;