APPS.AZW_HIER dependencies on AZ_WEBFORM_MESSAGES

Line 127: INSERT INTO az_webform_messages (mesg)

123: WHILE leaf_node_cursor%FOUND LOOP
124:
125: BEGIN
126: IF group_hierarchy_tree_not_found(v_group_id) THEN
127: INSERT INTO az_webform_messages (mesg)
128: VALUES (v_group_id);
129:
130: END IF;
131:

Line 141: fnd_message.set_token('AZW_ERROR_STMT','insert into az_webform_messages');

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:
145: FETCH leaf_node_cursor INTO v_group_id;

Line 253: az_webform_messages azm

249: wav.display_name
250: FROM az_processes azp,
251: az_flow_phases_v azfpv,
252: wf_activities_vl wav,
253: az_webform_messages azm
254: WHERE azfpv.item_type = azp.item_type
255: AND azfpv.process_name = azp.process_name
256: AND azp.process_type = g_current_mode
257: AND wav.item_type = azp.item_type

Line 676: INSERT INTO az_webform_messages (mesg)

672: END IF; /* p_sort_by = 'PH'or 'C' */
673: END IF; /* v_rollup_flag = 'N' */
674: ELSE
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;

Line 686: fnd_message.set_token('AZW_ERROR_STMT','insert into az_webform_messages');

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,
690: p_assigned_user, p_task_status,

Line 1642: INSERT INTO az_webform_messages (mesg)

1638: BEGIN
1639: -- Somehow table.COUNT doesn't work.. so use i, which is the count of rows
1640: IF i > 0 THEN
1641: FORALL k IN 1..i
1642: INSERT INTO az_webform_messages (mesg)
1643: VALUES (msg(k));
1644: END IF;
1645:
1646: EXCEPTION

Line 1654: fnd_message.set_token('AZW_ERROR_STMT','insert into az_webform_messages');

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:
1658: EXCEPTION