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 DBMS_OUTPUT

Line 86: --DBMS_OUTPUT.PUT_LINE('error: group_hierarchy_tree_not_found: ' || SQLERRM);

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

Line 119: -- DBMS_OUTPUT.PUT_LINE('leaf nodes: get_leaf_nodes: ' );

115: ORDER BY group_id;
116:
117: BEGIN
118:
119: -- DBMS_OUTPUT.PUT_LINE('leaf nodes: get_leaf_nodes: ' );
120: OPEN leaf_node_cursor;
121: FETCH leaf_node_cursor INTO v_group_id;
122:
123: WHILE leaf_node_cursor%FOUND LOOP

Line 136: --DBMS_OUTPUT.PUT_LINE('error: get_leaf_nodes: ' || SQLERRM);

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

Line 264: -- dbms_output.put_line('get process hierarchy' || process_status);

260: AND azp.parent_id = azm.mesg
261: ORDER BY wav.display_name, azp.context_type, azp.context_name;
262:
263: BEGIN
264: -- dbms_output.put_line('get process hierarchy' || process_status);
265:
266: -- assign the local variables
267: p_assigned_user := assigned_user;
268: p_task_status := task_status;

Line 333: -- dbms_output.put_line('data found for PN sort ny and not all groups');

329: END;
330: ELSE /* p_sort_by = 'PN' */
331: BEGIN
332: FOR data IN process_hierarchy_pn LOOP
333: -- dbms_output.put_line('data found for PN sort ny and not all groups');
334: IF (data.context_name is null) THEN
335: label := data.display_name || data.context_name ||
336: ' [' || TO_CHAR(data.phase) || ']';
337: ELSE

Line 367: -- dbms_output.put_line('process' || label);

363: hierarchy_table(t_index).status := 'INCOMPLETE';
364: END IF; /* UPPER(data.status_code) = 'Y' */
365:
366: hierarchy_table(t_index).display_order := display_id;
367: -- dbms_output.put_line('process' || label);
368:
369: END IF; /* data.phase = process_phase OR process_phase = 0 */
370: END IF;
371:

Line 388: --DBMS_OUTPUT.PUT_LINE('error: get_process: ' || SQLERRM);

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

Line 449: --dbms_output.put_line('get group hierarchy tree: '|| process_group);

445: ORDER BY 1;
446:
447: BEGIN
448:
449: --dbms_output.put_line('get group hierarchy tree: '|| process_group);
450:
451: p_process_group := process_group;
452: p_process_status := process_status;
453: p_process_phase := process_phase;

Line 470: --dbms_output.put_line('Getting processes for group : ' || v_node_id);

466: WHILE group_hierarchy_tree_cursor%FOUND LOOP
467:
468: IF group_hierarchy_tree_not_found(v_node_id) THEN
469: -- this group is a LEAF group
470: --dbms_output.put_line('Getting processes for group : ' || v_node_id);
471:
472: get_process(v_rollup_flag, v_node_id, p_process_status,
473: p_process_phase,
474: p_assigned_user, p_task_status,

Line 478: -- dbms_output.put_line('Completed get_process for group : ' || v_node_id);

474: p_assigned_user, p_task_status,
475: p_task_total_days, p_task_total_days_op,
476: p_sort_by);
477:
478: -- dbms_output.put_line('Completed get_process for group : ' || v_node_id);
479:
480: IF v_rollup_flag = 'N' THEN
481:
482: -- insert this group as a node

Line 502: -- dbms_output.put_line('Inserted group : ' || v_node_id);

498: hierarchy_table(t_index).node_type := 'G';
499: hierarchy_table(t_index).status := 'INCOMPLETE';
500: hierarchy_table(t_index).display_order := v_display_order;
501:
502: -- dbms_output.put_line('Inserted group : ' || v_node_id);
503: END IF;
504: END IF;
505: ELSE
506: -- this group has children groups

Line 507: --dbms_output.put_line('Getting group_hierarchy_tree for group : ' || v_node_id);

503: END IF;
504: END IF;
505: ELSE
506: -- this group has children groups
507: --dbms_output.put_line('Getting group_hierarchy_tree for group : ' || v_node_id);
508:
509: get_group_hierarchy_tree(v_group_rollup_flag, v_node_id,
510: p_process_status, p_process_phase,
511: p_assigned_user,

Line 515: --dbms_output.put_line('Completed get_group_hierarchy_tree for group: ' || v_node_id);

511: p_assigned_user,
512: p_task_status, p_task_total_days,
513: p_task_total_days_op, p_sort_by);
514:
515: --dbms_output.put_line('Completed get_group_hierarchy_tree for group: ' || v_node_id);
516:
517: IF v_group_rollup_flag = 'N' THEN
518: -- insert this group as a node
519: group_rollup_flag := 'N';

Line 537: -- dbms_output.put_line('Inserted group : ' || v_node_id);

533: hierarchy_table(t_index).node_type := 'G';
534: hierarchy_table(t_index).status := 'INCOMPLETE';
535: hierarchy_table(t_index).display_order := v_display_order;
536:
537: -- dbms_output.put_line('Inserted group : ' || v_node_id);
538: END IF;
539: END IF;
540: END IF;
541:

Line 554: --dbms_output.put_line('*** Error: get_group_hierarchy_tree: ' || SQLERRM);

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

Line 604: -- dbms_output.enable(1000000);

600: v_group_rollup_flag VARCHAR2(1);
601:
602: BEGIN
603:
604: -- dbms_output.enable(1000000);
605: -- dbms_output.put_line('get grouping hierarchy');
606:
607: p_process_group := process_group;
608: p_process_status := process_status;

Line 605: -- dbms_output.put_line('get grouping hierarchy');

601:
602: BEGIN
603:
604: -- dbms_output.enable(1000000);
605: -- dbms_output.put_line('get grouping hierarchy');
606:
607: p_process_group := process_group;
608: p_process_status := process_status;
609: p_process_phase := process_phase;

Line 651: --dbms_output.put_line('Completed get_process for group : ' || v_node_id);

647: p_assigned_user, p_task_status,
648: p_task_total_days, p_task_total_days_op,
649: p_sort_by);
650:
651: --dbms_output.put_line('Completed get_process for group : ' || v_node_id);
652:
653: IF v_rollup_flag = 'N' THEN
654: root_rollup_flag := 'N';
655:

Line 698: --dbms_output.put_line('Getting group_hierarchy_tree for group : ' || v_node_id);

694:
695: ELSE
696:
697: IF (p_sort_by = 'PH' OR p_sort_by = 'C') THEN
698: --dbms_output.put_line('Getting group_hierarchy_tree for group : ' || v_node_id);
699: get_group_hierarchy_tree(v_group_rollup_flag, v_node_id,
700: p_process_status, p_process_phase,
701: p_assigned_user,
702: p_task_status, p_task_total_days,

Line 705: --dbms_output.put_line('Completed get_group_hierarchy_tree for group: '||v_node_id);

701: p_assigned_user,
702: p_task_status, p_task_total_days,
703: p_task_total_days_op, p_sort_by);
704:
705: --dbms_output.put_line('Completed get_group_hierarchy_tree for group: '||v_node_id);
706:
707: IF v_group_rollup_flag = 'N' THEN
708: root_rollup_flag := 'N';
709: t_index := t_index + 1;

Line 744: --dbms_output.put_line('*** Error: get_group_hierarchy: ' || SQLERRM);

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

Line 907: -- dbms_output.enable(1000000);

903: ORDER BY 1;
904:
905: BEGIN
906:
907: -- dbms_output.enable(1000000);
908: -- dbms_output.put_line('get grouping hierarchy');
909: -- get all the root groups and create root for them
910:
911: BEGIN

Line 908: -- dbms_output.put_line('get grouping hierarchy');

904:
905: BEGIN
906:
907: -- dbms_output.enable(1000000);
908: -- dbms_output.put_line('get grouping hierarchy');
909: -- get all the root groups and create root for them
910:
911: BEGIN
912: OPEN root_group_hierarchy_cursor;

Line 1080: --dbms_output.put_line('getting data for process 2' || data.display_name);

1076: ELSE
1077: label := data.display_name || ': ' || data.context_name
1078: || ' [' || TO_CHAR(data.phase) || ']';
1079: END IF;
1080: --dbms_output.put_line('getting data for process 2' || data.display_name);
1081:
1082: IF (((process_status <> 'ALL') AND (data.status_code = process_status))
1083: OR
1084: (process_status = 'ALL')

Line 1108: --dbms_output.put_line('inserted process ' || label);

1104: hierarchy_table(t_index).status := 'INCOMPLETE';
1105: END IF;
1106: hierarchy_table(t_index).display_order := display_id;
1107:
1108: --dbms_output.put_line('inserted process ' || label);
1109: END IF;
1110: END IF;
1111: END LOOP;
1112: EXCEPTION

Line 1319: -- dbms_output.put_line('get tasks all hierarchy');

1315: AND wav.type = 'NOTICE'
1316: ORDER BY wias.begin_date desc;
1317:
1318: BEGIN
1319: -- dbms_output.put_line('get tasks all hierarchy');
1320: -- dbms_output.put_line('Done with lookups');
1321: -- Get iterations for processes
1322: -- dbms_output.put_line('Task status is :' || p_task_status);
1323: -- dbms_output.put_line('getting all statuses tasks');

Line 1320: -- dbms_output.put_line('Done with lookups');

1316: ORDER BY wias.begin_date desc;
1317:
1318: BEGIN
1319: -- dbms_output.put_line('get tasks all hierarchy');
1320: -- dbms_output.put_line('Done with lookups');
1321: -- Get iterations for processes
1322: -- dbms_output.put_line('Task status is :' || p_task_status);
1323: -- dbms_output.put_line('getting all statuses tasks');
1324: -- Get all tasks one at a time

Line 1322: -- dbms_output.put_line('Task status is :' || p_task_status);

1318: BEGIN
1319: -- dbms_output.put_line('get tasks all hierarchy');
1320: -- dbms_output.put_line('Done with lookups');
1321: -- Get iterations for processes
1322: -- dbms_output.put_line('Task status is :' || p_task_status);
1323: -- dbms_output.put_line('getting all statuses tasks');
1324: -- Get all tasks one at a time
1325:
1326: OPEN az_item_types;

Line 1323: -- dbms_output.put_line('getting all statuses tasks');

1319: -- dbms_output.put_line('get tasks all hierarchy');
1320: -- dbms_output.put_line('Done with lookups');
1321: -- Get iterations for processes
1322: -- dbms_output.put_line('Task status is :' || p_task_status);
1323: -- dbms_output.put_line('getting all statuses tasks');
1324: -- Get all tasks one at a time
1325:
1326: OPEN az_item_types;
1327: FETCH az_item_types

Line 1345: --dbms_output.put_line('Found all statuses tasks: ' || v_item_key);

1341:
1342: BEGIN
1343:
1344: WHILE az_tasks_cursor%FOUND LOOP
1345: --dbms_output.put_line('Found all statuses tasks: ' || v_item_key);
1346: display_id := display_id + 1;
1347:
1348: OPEN az_task_display_cursor;
1349: FETCH az_task_display_cursor

Line 1353: --dbms_output.put_line('Opening count cursor');

1349: FETCH az_task_display_cursor
1350: INTO v_display_string, v_days_since,
1351: v_dummy_begin_date;
1352:
1353: --dbms_output.put_line('Opening count cursor');
1354:
1355: OPEN az_steps_count_cursor;
1356: FETCH az_steps_count_cursor INTO v_count;
1357:

Line 1361: --dbms_output.put_line('count: ' || v_count);

1357:
1358: OPEN az_skip_count_cursor;
1359: FETCH az_skip_count_cursor INTO v_skip_count;
1360:
1361: --dbms_output.put_line('count: ' || v_count);
1362:
1363: IF(((p_task_tot_days_op = '=') AND (v_task_tot_days = p_task_tot_days))
1364: OR
1365: ((p_task_tot_days_op = '>') AND (v_task_tot_days > p_task_tot_days))

Line 1382: -- dbms_output.put_line('inserting task');

1378: AND ((v_process_phase = p_process_phase) OR (p_process_phase = 0))
1379: AND (((v_status_code = p_process_status) OR (p_process_status = 'ALL'))
1380: OR (( p_process_status = 'I') AND ((v_status_code = 'A') OR (v_status_code = 'N'))))
1381: THEN
1382: -- dbms_output.put_line('inserting task');
1383: BEGIN
1384: t_index := t_index + 1;
1385: hierarchy_table(t_index).node_id := v_item_type || '.' ||
1386: v_root_activity || '.'|| v_context_id || '.' || v_item_key;

Line 1514: dbms_output.enable(1000000);

1510:
1511: -- End: added by swarup for context sort
1512:
1513: BEGIN
1514: dbms_output.enable(1000000);
1515: -- DBMS_OUTPUT.PUT_LINE('get_hierarchy: ');
1516: -- assign the variables
1517: p_process_status := process_status;
1518: p_process_group := process_group;

Line 1515: -- DBMS_OUTPUT.PUT_LINE('get_hierarchy: ');

1511: -- End: added by swarup for context sort
1512:
1513: BEGIN
1514: dbms_output.enable(1000000);
1515: -- DBMS_OUTPUT.PUT_LINE('get_hierarchy: ');
1516: -- assign the variables
1517: p_process_status := process_status;
1518: p_process_group := process_group;
1519: p_process_phase := process_phase;

Line 1571: --dbms_output.put_line('Calling');

1567: get_all_task(p_process_status, p_process_phase, p_assigned_user,
1568: p_task_status, p_task_total_days, p_task_total_days_op, p_sort_by);
1569: ELSE
1570: -- get groups which then get processes and tasks recursively
1571: --dbms_output.put_line('Calling');
1572: get_group_hierarchy(v_root_rollup_flag, p_process_group,p_process_status,
1573: p_process_phase, p_assigned_user,
1574: p_task_status, p_task_total_days,
1575: p_task_total_days_op, p_sort_by);

Line 1591: -- dbms_output.put_line('TYPE: ' || v_context_type ||' meaning: ' || v_meaning );

1587: WHILE get_context_types_c%FOUND LOOP
1588: -- Make nodes with Context Names with each context type
1589: -- This will add all groups and their sub groups under
1590: -- each node
1591: -- dbms_output.put_line('TYPE: ' || v_context_type ||' meaning: ' || v_meaning );
1592: ctx_table.delete ;
1593:
1594: IF UPPER(v_context_type) = 'NONE' THEN
1595: ctx_table(1).context_name := v_context_type;

Line 1662: --DBMS_OUTPUT.PUT_LINE('error: get_hierarchy: ' || SQLERRM);

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

Line 1690: --dbms_output.put_line('Here: '|| parent_id );

1686: IF ( hierarchy_table(j).node_type = 'G') THEN
1687: NULL;
1688: ELSE
1689: parent_id := hierarchy_table(j).parent_node_id;
1690: --dbms_output.put_line('Here: '|| parent_id );
1691: IF ( hierarchy_table(j).node_type = 'P') THEN
1692:
1693: p_context_type := hierarchy_table(j).context_type;
1694: p_context_name := hierarchy_table(j).context_name;

Line 1717: --DBMS_OUTPUT.PUT_LINE('error: insert_proc_task_for_context: ' || SQLERRM);

1713: END IF;
1714: END LOOP;
1715: EXCEPTION
1716: WHEN OTHERS THEN
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');

Line 1790: --DBMS_OUTPUT.PUT_LINE('error: insert_context: ' || SQLERRM);

1786: END LOOP;
1787: END IF;
1788: EXCEPTION
1789: WHEN OTHERS THEN
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');

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