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 AZW_HIER

Line 1: PACKAGE BODY AZW_HIER AS

1: PACKAGE BODY AZW_HIER AS
2: /* $Header: AZWHIERB.pls 115.51 1999/11/09 12:52:57 pkm ship $: */
3:
4: TYPE message_tbl_t IS TABLE OF VARCHAR2(1024) INDEX BY BINARY_INTEGER;
5:

Line 90: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.group_hierarchy_tree_not_found');

86: --DBMS_OUTPUT.PUT_LINE('error: group_hierarchy_tree_not_found: ' || SQLERRM);
87: fnd_message.set_name('AZ','AZW_PLSQL_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:

Line 140: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_leaf_nodes');

136: --DBMS_OUTPUT.PUT_LINE('error: get_leaf_nodes: ' || SQLERRM);
137: fnd_message.set_name('AZ','AZW_PLSQL_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:

Line 157: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_leaf_nodes');

153: WHEN OTHERS THEN
154: fnd_message.set_name('AZ','AZW_PLSQL_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:

Line 326: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_process');

322: WHEN OTHERS THEN
323: fnd_message.set_name('AZ','AZW_PLSQL_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' */

Line 378: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_process');

374: WHEN OTHERS THEN
375: fnd_message.set_name('AZ','AZW_PLSQL_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' */

Line 392: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_process');

388: --DBMS_OUTPUT.PUT_LINE('error: get_process: ' || SQLERRM);
389: fnd_message.set_name('AZ','AZW_PLSQL_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;

Line 558: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_group_hierarchy_tree');

554: --dbms_output.put_line('*** Error: get_group_hierarchy_tree: ' || SQLERRM);
555: fnd_message.set_name('AZ','AZW_PLSQL_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;

Line 634: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_group_hierarchy');

630: WHEN OTHERS THEN
631: fnd_message.set_name('AZ','AZW_PLSQL_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:

Line 685: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_group_hierarchy');

681: WHEN OTHERS THEN
682: fnd_message.set_name('AZ','AZW_PLSQL_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,

Line 748: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_group_hierarchy');

744: --dbms_output.put_line('*** Error: get_group_hierarchy: ' || SQLERRM);
745: fnd_message.set_name('AZ','AZW_PLSQL_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:

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

776: WHEN OTHERS THEN
777: fnd_message.set_name('AZ','AZW_PLSQL_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;

Line 800: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.tast_init');

796: WHEN OTHERS THEN
797: fnd_message.set_name('AZ','AZW_PLSQL_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:

Line 819: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.tast_init');

815: WHEN OTHERS THEN
816: fnd_message.set_name('AZ','AZW_PLSQL_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:

Line 838: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.tast_init');

834: WHEN OTHERS THEN
835: fnd_message.set_name('AZ','AZW_PLSQL_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:

Line 857: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.tast_init');

853: WHEN OTHERS THEN
854: fnd_message.set_name('AZ','AZW_PLSQL_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;

Line 945: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_group_hierarchy');

941: WHEN OTHERS THEN
942: fnd_message.set_name('AZ','AZW_PLSQL_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:

Line 986: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_group_hierarchy');

982: WHEN OTHERS THEN
983: fnd_message.set_name('AZ','AZW_PLSQL_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:

Line 998: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_group_hierarchy');

994: WHEN OTHERS THEN
995: fnd_message.set_name('AZ','AZW_PLSQL_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;

Line 1119: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_process');

1115: WHEN OTHERS THEN
1116: fnd_message.set_name('AZ','AZW_PLSQL_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:

Line 1169: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_process');

1165: WHEN OTHERS THEN
1166: fnd_message.set_name('AZ','AZW_PLSQL_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;

Line 1182: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_process');

1178: WHEN OTHERS THEN
1179: fnd_message.set_name('AZ','AZW_PLSQL_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;

Line 1414: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_task');

1410: WHEN OTHERS THEN
1411: fnd_message.set_name('AZ','AZW_PLSQL_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;

Line 1440: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_task');

1436: WHEN OTHERS THEN
1437: fnd_message.set_name('AZ','AZW_PLSQL_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:

Line 1457: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_task');

1453: WHEN OTHERS THEN
1454: fnd_message.set_name('AZ','AZW_PLSQL_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;

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

1540: WHEN OTHERS THEN
1541: fnd_message.set_name('AZ','AZW_PLSQL_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:

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

1614: WHEN OTHERS THEN
1615: fnd_message.set_name('AZ','AZW_PLSQL_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:

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

1649: WHEN OTHERS THEN
1650: fnd_message.set_name('AZ','AZW_PLSQL_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:

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

1662: --DBMS_OUTPUT.PUT_LINE('error: get_hierarchy: ' || SQLERRM);
1663: fnd_message.set_name('AZ','AZW_PLSQL_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;

Line 1721: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.insert_proc_task_for_context');

1717: --DBMS_OUTPUT.PUT_LINE('error: insert_proc_task_for_context: ' || SQLERRM);
1718: fnd_message.set_name('AZ','AZW_PLSQL_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:

Line 1794: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.insert_context');

1790: --DBMS_OUTPUT.PUT_LINE('error: insert_context: ' || SQLERRM);
1791: fnd_message.set_name('AZ','AZW_PLSQL_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:

Line 1883: --DBMS_OUTPUT.PUT_LINE('AZW_HIER.insert_groups_for_context: ' || SQLERRM);

1879: END IF;
1880: END LOOP;
1881: EXCEPTION
1882: WHEN OTHERS THEN
1883: --DBMS_OUTPUT.PUT_LINE('AZW_HIER.insert_groups_for_context: ' || SQLERRM);
1884: fnd_message.set_name('AZ','AZW_PLSQL_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');

Line 1887: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.insert_groups_for_context');

1883: --DBMS_OUTPUT.PUT_LINE('AZW_HIER.insert_groups_for_context: ' || SQLERRM);
1884: fnd_message.set_name('AZ','AZW_PLSQL_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:

Line 1924: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_context');

1920: WHEN OTHERS THEN
1921: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1922: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1923: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1924: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_context');
1925: fnd_message.set_token('AZW_ERROR_STMT','cursor select from az_processes ');
1926: END get_context;
1927:
1928: END AZW_HIER;

Line 1928: END AZW_HIER;

1924: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_context');
1925: fnd_message.set_token('AZW_ERROR_STMT','cursor select from az_processes ');
1926: END get_context;
1927:
1928: END AZW_HIER;