eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AZW_HIER dependencies on APP_EXCEPTION

Line 83: WHEN app_exception.application_exception THEN

79:
80: RETURN ret;
81:
82: EXCEPTION
83: WHEN app_exception.application_exception THEN
84: RAISE ;
85: WHEN OTHERS THEN
86: --DBMS_OUTPUT.PUT_LINE('error: group_hierarchy_tree_not_found: ' || SQLERRM);
87: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

Line 92: APP_EXCEPTION.RAISE_EXCEPTION;

88: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
89: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
90: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.group_hierarchy_tree_not_found');
91: fnd_message.set_token('AZW_ERROR_STMT','select count(*) from az_groups');
92: APP_EXCEPTION.RAISE_EXCEPTION;
93: END group_hierarchy_tree_not_found;
94:
95:
96: --

Line 133: WHEN app_exception.application_exception THEN

129:
130: END IF;
131:
132: EXCEPTION
133: WHEN app_exception.application_exception THEN
134: RAISE ;
135: WHEN OTHERS THEN
136: --DBMS_OUTPUT.PUT_LINE('error: get_leaf_nodes: ' || SQLERRM);
137: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

Line 142: APP_EXCEPTION.RAISE_EXCEPTION;

138: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
139: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
140: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_leaf_nodes');
141: fnd_message.set_token('AZW_ERROR_STMT','insert into az_webform_messages');
142: APP_EXCEPTION.RAISE_EXCEPTION;
143: END;
144:
145: FETCH leaf_node_cursor INTO v_group_id;
146:

Line 151: WHEN app_exception.application_exception THEN

147: END LOOP;
148: CLOSE leaf_node_cursor;
149:
150: EXCEPTION
151: WHEN app_exception.application_exception THEN
152: RAISE ;
153: WHEN OTHERS THEN
154: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
155: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

Line 159: APP_EXCEPTION.RAISE_EXCEPTION;

155: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
156: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
157: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_leaf_nodes');
158: fnd_message.set_token('AZW_ERROR_STMT','CURSOR leaf_node_cursor');
159: APP_EXCEPTION.RAISE_EXCEPTION;
160: END get_leaf_nodes;
161:
162: --
163: -- get_process

Line 320: WHEN app_exception.application_exception THEN

316: END IF; /* process_status <> 'A' AND data.complete_flag = process_status */
317: END LOOP;
318:
319: EXCEPTION
320: WHEN app_exception.application_exception THEN
321: RAISE;
322: WHEN OTHERS THEN
323: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
324: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

Line 328: APP_EXCEPTION.RAISE_EXCEPTION;

324: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
325: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
326: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_process');
327: fnd_message.set_token('AZW_ERROR_STMT','CURSOR process_hierarchy_ph');
328: APP_EXCEPTION.RAISE_EXCEPTION;
329: END;
330: ELSE /* p_sort_by = 'PN' */
331: BEGIN
332: FOR data IN process_hierarchy_pn LOOP

Line 380: APP_EXCEPTION.RAISE_EXCEPTION;

376: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
377: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
378: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_process');
379: fnd_message.set_token('AZW_ERROR_STMT','CURSOR process_hierarchy_pn');
380: APP_EXCEPTION.RAISE_EXCEPTION;
381: END;
382: END IF; /* p_sort_by = 'PH' */
383:
384: EXCEPTION

Line 385: WHEN app_exception.application_exception THEN

381: END;
382: END IF; /* p_sort_by = 'PH' */
383:
384: EXCEPTION
385: WHEN app_exception.application_exception THEN
386: RAISE;
387: WHEN OTHERS THEN
388: --DBMS_OUTPUT.PUT_LINE('error: get_process: ' || SQLERRM);
389: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

Line 394: APP_EXCEPTION.RAISE_EXCEPTION;

390: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
391: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
392: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_process');
393: fnd_message.set_token('AZW_ERROR_STMT','CURSOR process_hierarchy_pn/ph');
394: APP_EXCEPTION.RAISE_EXCEPTION;
395:
396: END get_process;
397:
398:

Line 551: WHEN app_exception.application_exception THEN

547:
548: CLOSE group_hierarchy_tree_cursor;
549:
550: EXCEPTION
551: WHEN app_exception.application_exception THEN
552: RAISE;
553: WHEN OTHERS THEN
554: --dbms_output.put_line('*** Error: get_group_hierarchy_tree: ' || SQLERRM);
555: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

Line 560: APP_EXCEPTION.RAISE_EXCEPTION;

556: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
557: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
558: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_group_hierarchy_tree');
559: fnd_message.set_token('AZW_ERROR_STMT','CURSOR group_hierarchy_tree_cursor');
560: APP_EXCEPTION.RAISE_EXCEPTION;
561:
562: END get_group_hierarchy_tree;
563:
564:

Line 628: WHEN app_exception.application_exception THEN

624: WHERE group_id = v_node_id
625: AND process_type = g_current_mode;
626:
627: EXCEPTION
628: WHEN app_exception.application_exception THEN
629: RAISE;
630: WHEN OTHERS THEN
631: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
632: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

Line 636: APP_EXCEPTION.RAISE_EXCEPTION;

632: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
633: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
634: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_group_hierarchy');
635: fnd_message.set_token('AZW_ERROR_STMT','select lookup_code ... from az_groups');
636: APP_EXCEPTION.RAISE_EXCEPTION;
637: END;
638:
639: IF group_hierarchy_tree_not_found(v_node_id) THEN
640:

Line 679: WHEN app_exception.application_exception THEN

675: BEGIN
676: INSERT INTO az_webform_messages (mesg)
677: VALUES (v_node_id);
678: EXCEPTION
679: WHEN app_exception.application_exception THEN
680: RAISE;
681: WHEN OTHERS THEN
682: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
683: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

Line 687: APP_EXCEPTION.RAISE_EXCEPTION;

683: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
684: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
685: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_group_hierarchy');
686: fnd_message.set_token('AZW_ERROR_STMT','insert into az_webform_messages');
687: APP_EXCEPTION.RAISE_EXCEPTION;
688: END;
689: get_process(v_rollup_flag, v_node_id, p_process_status,p_process_phase,
690: p_assigned_user, p_task_status,
691: p_task_total_days, p_task_total_days_op, p_sort_by);

Line 741: WHEN app_exception.application_exception THEN

737:
738: END IF; /* group_hierarchy_tree_not_found(v_node_id) */
739:
740: EXCEPTION
741: WHEN app_exception.application_exception THEN
742: RAISE;
743: WHEN OTHERS THEN
744: --dbms_output.put_line('*** Error: get_group_hierarchy: ' || SQLERRM);
745: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

Line 750: APP_EXCEPTION.RAISE_EXCEPTION;

746: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
747: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
748: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_group_hierarchy');
749: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
750: APP_EXCEPTION.RAISE_EXCEPTION;
751: END get_group_hierarchy;
752:
753:
754: --

Line 774: WHEN app_exception.application_exception THEN

770: from fnd_languages
771: where NLS_LANGUAGE =
772: SUBSTR(USERENV('LANGUAGE'), 1, INSTR(USERENV('LANGUAGE'), '_')-1);
773: EXCEPTION
774: WHEN app_exception.application_exception THEN
775: RAISE;
776: WHEN OTHERS THEN
777: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
778: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

Line 782: APP_EXCEPTION.RAISE_EXCEPTION;

778: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
779: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
780: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_hierarchy');
781: fnd_message.set_token('AZW_ERROR_STMT','select language_code ... from fnd_languages');
782: APP_EXCEPTION.RAISE_EXCEPTION;
783: END;
784: END IF;
785:
786: BEGIN

Line 794: WHEN app_exception.application_exception THEN

790: WHERE language = v_language_code
791: AND type = 'WFTKN'
792: AND name = 'DAYS';
793: EXCEPTION
794: WHEN app_exception.application_exception THEN
795: RAISE;
796: WHEN OTHERS THEN
797: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
798: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

Line 802: APP_EXCEPTION.RAISE_EXCEPTION;

798: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
799: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
800: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.tast_init');
801: fnd_message.set_token('AZW_ERROR_STMT','select text into v_days from wf_resources');
802: APP_EXCEPTION.RAISE_EXCEPTION;
803: END;
804:
805: BEGIN
806: SELECT SUBSTRB(text, 0, 8)

Line 813: WHEN app_exception.application_exception THEN

809: WHERE language = v_language_code
810: AND type = 'WFTKN'
811: AND name = 'WFMON_DONE';
812: EXCEPTION
813: WHEN app_exception.application_exception THEN
814: RAISE;
815: WHEN OTHERS THEN
816: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
817: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

Line 821: APP_EXCEPTION.RAISE_EXCEPTION;

817: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
818: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
819: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.tast_init');
820: fnd_message.set_token('AZW_ERROR_STMT','select text into v_done from wf_resources');
821: APP_EXCEPTION.RAISE_EXCEPTION;
822: END;
823:
824: BEGIN
825: SELECT SUBSTRB(text, 0, 8)

Line 832: WHEN app_exception.application_exception THEN

828: WHERE language = v_language_code
829: AND type = 'WFTKN'
830: AND name = 'WFMON_SKIP';
831: EXCEPTION
832: WHEN app_exception.application_exception THEN
833: RAISE;
834: WHEN OTHERS THEN
835: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
836: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

Line 840: APP_EXCEPTION.RAISE_EXCEPTION;

836: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
837: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
838: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.tast_init');
839: fnd_message.set_token('AZW_ERROR_STMT','select text into v_skip from wf_resources');
840: APP_EXCEPTION.RAISE_EXCEPTION;
841: END;
842:
843: BEGIN
844: SELECT SUBSTRB(text, 0, 16)

Line 851: WHEN app_exception.application_exception THEN

847: WHERE language = v_language_code
848: AND type = 'WFTKN'
849: AND name = 'PRIORITY';
850: EXCEPTION
851: WHEN app_exception.application_exception THEN
852: RAISE;
853: WHEN OTHERS THEN
854: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
855: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

Line 859: APP_EXCEPTION.RAISE_EXCEPTION;

855: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
856: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
857: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.tast_init');
858: fnd_message.set_token('AZW_ERROR_STMT','select text into v_priority_display from wf_resources');
859: APP_EXCEPTION.RAISE_EXCEPTION;
860: END;
861: END task_init;
862:
863:

Line 939: WHEN app_exception.application_exception THEN

935: INTO v_node_id, v_dependency_parent_id, v_display_order,
936: v_application_id, v_lookup_code;
937: END LOOP;
938: EXCEPTION
939: WHEN app_exception.application_exception THEN
940: RAISE;
941: WHEN OTHERS THEN
942: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
943: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

Line 947: APP_EXCEPTION.RAISE_EXCEPTION;

943: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
944: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
945: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_group_hierarchy');
946: fnd_message.set_token('AZW_ERROR_STMT','CURSOR root_group_hierarchy_cursor');
947: APP_EXCEPTION.RAISE_EXCEPTION;
948: END;
949:
950: -- get all the remaining hierarchy leaf groups and insert into hierarchy table
951: BEGIN

Line 980: WHEN app_exception.application_exception THEN

976: v_application_id, v_lookup_code;
977: END LOOP;
978:
979: EXCEPTION
980: WHEN app_exception.application_exception THEN
981: RAISE;
982: WHEN OTHERS THEN
983: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
984: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

Line 988: APP_EXCEPTION.RAISE_EXCEPTION;

984: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
985: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
986: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_group_hierarchy');
987: fnd_message.set_token('AZW_ERROR_STMT','CURSOR group_hierarchy_cursor');
988: APP_EXCEPTION.RAISE_EXCEPTION;
989: END;
990:
991: EXCEPTION
992: WHEN app_exception.application_exception THEN

Line 992: WHEN app_exception.application_exception THEN

988: APP_EXCEPTION.RAISE_EXCEPTION;
989: END;
990:
991: EXCEPTION
992: WHEN app_exception.application_exception THEN
993: RAISE;
994: WHEN OTHERS THEN
995: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
996: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

Line 1000: APP_EXCEPTION.RAISE_EXCEPTION;

996: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
997: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
998: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_group_hierarchy');
999: fnd_message.set_token('AZW_ERROR_STMT','CURSOR group_hierarchy_cursor');
1000: APP_EXCEPTION.RAISE_EXCEPTION;
1001:
1002: END get_all_group_hierarchy;
1003:
1004:

Line 1113: WHEN app_exception.application_exception THEN

1109: END IF;
1110: END IF;
1111: END LOOP;
1112: EXCEPTION
1113: WHEN app_exception.application_exception THEN
1114: RAISE;
1115: WHEN OTHERS THEN
1116: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1117: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

Line 1121: APP_EXCEPTION.RAISE_EXCEPTION;

1117: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1118: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1119: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_process');
1120: fnd_message.set_token('AZW_ERROR_STMT','CURSOR process_hierarchy_ph');
1121: APP_EXCEPTION.RAISE_EXCEPTION;
1122: END;
1123:
1124: ELSE
1125: -- When sort by is by Process Name

Line 1163: WHEN app_exception.application_exception THEN

1159: END IF;
1160: END IF;
1161: END LOOP;
1162: EXCEPTION
1163: WHEN app_exception.application_exception THEN
1164: RAISE;
1165: WHEN OTHERS THEN
1166: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1167: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

Line 1171: APP_EXCEPTION.RAISE_EXCEPTION;

1167: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1168: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1169: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_process');
1170: fnd_message.set_token('AZW_ERROR_STMT','CURSOR process_hierarchy_pn_all');
1171: APP_EXCEPTION.RAISE_EXCEPTION;
1172: END;
1173: END IF;
1174:
1175: EXCEPTION

Line 1176: WHEN app_exception.application_exception THEN

1172: END;
1173: END IF;
1174:
1175: EXCEPTION
1176: WHEN app_exception.application_exception THEN
1177: RAISE;
1178: WHEN OTHERS THEN
1179: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1180: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

Line 1184: APP_EXCEPTION.RAISE_EXCEPTION;

1180: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1181: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1182: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_process');
1183: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1184: APP_EXCEPTION.RAISE_EXCEPTION;
1185:
1186: END get_all_process;
1187:
1188:

Line 1408: WHEN app_exception.application_exception THEN

1404:
1405: hierarchy_table(t_index).display_order := display_id;
1406:
1407: EXCEPTION
1408: WHEN app_exception.application_exception THEN
1409: RAISE;
1410: WHEN OTHERS THEN
1411: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1412: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

Line 1416: APP_EXCEPTION.RAISE_EXCEPTION;

1412: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1413: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1414: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_task');
1415: fnd_message.set_token('AZW_ERROR_STMT','while inserting task to hierarchy table');
1416: APP_EXCEPTION.RAISE_EXCEPTION;
1417: END;
1418: END IF;
1419: END IF;
1420:

Line 1434: WHEN app_exception.application_exception THEN

1430:
1431: CLOSE az_tasks_cursor;
1432:
1433: EXCEPTION
1434: WHEN app_exception.application_exception THEN
1435: RAISE;
1436: WHEN OTHERS THEN
1437: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1438: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

Line 1442: APP_EXCEPTION.RAISE_EXCEPTION;

1438: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1439: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1440: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_task');
1441: fnd_message.set_token('AZW_ERROR_STMT','While looping in CURSOR az_tasks_cursor');
1442: APP_EXCEPTION.RAISE_EXCEPTION;
1443: END;
1444:
1445: FETCH az_item_types
1446: INTO v_item_type_p;

Line 1451: WHEN app_exception.application_exception THEN

1447: END LOOP;
1448: CLOSE az_item_types;
1449:
1450: EXCEPTION
1451: WHEN app_exception.application_exception THEN
1452: RAISE;
1453: WHEN OTHERS THEN
1454: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1455: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

Line 1459: APP_EXCEPTION.RAISE_EXCEPTION;

1455: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1456: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1457: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_task');
1458: fnd_message.set_token('AZW_ERROR_STMT','While looping in CURSOR az_item_types');
1459: APP_EXCEPTION.RAISE_EXCEPTION;
1460:
1461: END get_all_task;
1462:
1463:

Line 1538: WHEN app_exception.application_exception THEN

1534: where NLS_LANGUAGE =
1535: SUBSTR(USERENV('LANGUAGE'), 1, INSTR(USERENV('LANGUAGE'), '_')-1);
1536:
1537: EXCEPTION
1538: WHEN app_exception.application_exception THEN
1539: RAISE;
1540: WHEN OTHERS THEN
1541: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1542: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

Line 1546: APP_EXCEPTION.RAISE_EXCEPTION;

1542: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1543: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1544: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_hierarchy');
1545: fnd_message.set_token('AZW_ERROR_STMT','select language_code .. from fnd_languages');
1546: APP_EXCEPTION.RAISE_EXCEPTION;
1547: END;
1548:
1549: -- initialize the language specific display labels for task's label
1550: task_init;

Line 1612: WHEN app_exception.application_exception THEN

1608: END LOOP;
1609: CLOSE get_context_types_c ;
1610:
1611: EXCEPTION
1612: WHEN app_exception.application_exception THEN
1613: RAISE;
1614: WHEN OTHERS THEN
1615: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1616: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

Line 1620: APP_EXCEPTION.RAISE_EXCEPTION;

1616: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1617: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1618: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_hierarchy');
1619: fnd_message.set_token('AZW_ERROR_STMT','CURSOR get_context_types_c');
1620: APP_EXCEPTION.RAISE_EXCEPTION;
1621: END;
1622:
1623: -- Now insert processes/tasks for each their respective context
1624: insert_proc_task_for_context(msg, i);

Line 1647: WHEN app_exception.application_exception THEN

1643: VALUES (msg(k));
1644: END IF;
1645:
1646: EXCEPTION
1647: WHEN app_exception.application_exception THEN
1648: RAISE;
1649: WHEN OTHERS THEN
1650: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1651: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

Line 1655: APP_EXCEPTION.RAISE_EXCEPTION;

1651: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1652: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1653: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_hierarchy');
1654: fnd_message.set_token('AZW_ERROR_STMT','insert into az_webform_messages');
1655: APP_EXCEPTION.RAISE_EXCEPTION;
1656: END;
1657:
1658: EXCEPTION
1659: WHEN app_exception.application_exception THEN

Line 1659: WHEN app_exception.application_exception THEN

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

Line 1668: APP_EXCEPTION.RAISE_EXCEPTION;

1664: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1665: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1666: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_hierarchy');
1667: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1668: APP_EXCEPTION.RAISE_EXCEPTION;
1669:
1670: END get_hierarchy;
1671:
1672: /*---------------------------------------------------------------

Line 1723: APP_EXCEPTION.RAISE_EXCEPTION;

1719: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1720: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1721: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.insert_proc_task_for_context');
1722: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1723: APP_EXCEPTION.RAISE_EXCEPTION;
1724: END insert_proc_task_for_context;
1725:
1726: /*---------------------------------------------------------------
1727: * INSERT_CONTEXT

Line 1796: APP_EXCEPTION.RAISE_EXCEPTION;

1792: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1793: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1794: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.insert_context');
1795: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1796: APP_EXCEPTION.RAISE_EXCEPTION;
1797: END insert_context;
1798:
1799:
1800: FUNCTION validContextType( ctx_type IN VARCHAR2,p_node_id VARCHAR2) RETURN BOOLEAN IS

Line 1889: APP_EXCEPTION.RAISE_EXCEPTION;

1885: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1886: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1887: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.insert_groups_for_context');
1888: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1889: APP_EXCEPTION.RAISE_EXCEPTION;
1890: END insert_groups_for_context;
1891:
1892: /*---------------------------------------------------------------
1893: * get_context : private procedure