48: EXCEPTION
49: WHEN app_exception.application_exception THEN
50: RAISE;
51: WHEN OTHERS THEN
52: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
53: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
54: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
55: fnd_message.set_token('AZW_ERROR_PROC','azw_group.contains_processes');
56: fnd_message.set_token('AZW_ERROR_STMT','select count(*) into child_count from az_processes');
49: WHEN app_exception.application_exception THEN
50: RAISE;
51: WHEN OTHERS THEN
52: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
53: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
54: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
55: fnd_message.set_token('AZW_ERROR_PROC','azw_group.contains_processes');
56: fnd_message.set_token('AZW_ERROR_STMT','select count(*) into child_count from az_processes');
57: APP_EXCEPTION.RAISE_EXCEPTION;
50: RAISE;
51: WHEN OTHERS THEN
52: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
53: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
54: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
55: fnd_message.set_token('AZW_ERROR_PROC','azw_group.contains_processes');
56: fnd_message.set_token('AZW_ERROR_STMT','select count(*) into child_count from az_processes');
57: APP_EXCEPTION.RAISE_EXCEPTION;
58: END;
51: WHEN OTHERS THEN
52: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
53: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
54: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
55: fnd_message.set_token('AZW_ERROR_PROC','azw_group.contains_processes');
56: fnd_message.set_token('AZW_ERROR_STMT','select count(*) into child_count from az_processes');
57: APP_EXCEPTION.RAISE_EXCEPTION;
58: END;
59:
52: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
53: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
54: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
55: fnd_message.set_token('AZW_ERROR_PROC','azw_group.contains_processes');
56: fnd_message.set_token('AZW_ERROR_STMT','select count(*) into child_count from az_processes');
57: APP_EXCEPTION.RAISE_EXCEPTION;
58: END;
59:
60: --dbms_output.put_line('Here: '||child_count|| ' MODE: ' ||g_current_mode || ' P:'|| node_id);
77: EXCEPTION
78: WHEN app_exception.application_exception THEN
79: RAISE;
80: WHEN OTHERS THEN
81: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
82: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
83: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
84: fnd_message.set_token('AZW_ERROR_PROC','azw_group.contains_processes');
85: fnd_message.set_token('AZW_ERROR_STMT','CURSOR sub_group_c');
78: WHEN app_exception.application_exception THEN
79: RAISE;
80: WHEN OTHERS THEN
81: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
82: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
83: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
84: fnd_message.set_token('AZW_ERROR_PROC','azw_group.contains_processes');
85: fnd_message.set_token('AZW_ERROR_STMT','CURSOR sub_group_c');
86: APP_EXCEPTION.RAISE_EXCEPTION;
79: RAISE;
80: WHEN OTHERS THEN
81: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
82: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
83: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
84: fnd_message.set_token('AZW_ERROR_PROC','azw_group.contains_processes');
85: fnd_message.set_token('AZW_ERROR_STMT','CURSOR sub_group_c');
86: APP_EXCEPTION.RAISE_EXCEPTION;
87: END;
80: WHEN OTHERS THEN
81: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
82: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
83: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
84: fnd_message.set_token('AZW_ERROR_PROC','azw_group.contains_processes');
85: fnd_message.set_token('AZW_ERROR_STMT','CURSOR sub_group_c');
86: APP_EXCEPTION.RAISE_EXCEPTION;
87: END;
88: END IF;
81: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
82: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
83: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
84: fnd_message.set_token('AZW_ERROR_PROC','azw_group.contains_processes');
85: fnd_message.set_token('AZW_ERROR_STMT','CURSOR sub_group_c');
86: APP_EXCEPTION.RAISE_EXCEPTION;
87: END;
88: END IF;
89:
92: EXCEPTION
93: WHEN app_exception.application_exception THEN
94: RAISE;
95: WHEN OTHERS THEN
96: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
97: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
98: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
99: fnd_message.set_token('AZW_ERROR_PROC','azw_group.contains_processes');
100: fnd_message.set_token('AZW_ERROR_STMT','CURSOR sub_group_c');
93: WHEN app_exception.application_exception THEN
94: RAISE;
95: WHEN OTHERS THEN
96: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
97: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
98: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
99: fnd_message.set_token('AZW_ERROR_PROC','azw_group.contains_processes');
100: fnd_message.set_token('AZW_ERROR_STMT','CURSOR sub_group_c');
101: APP_EXCEPTION.RAISE_EXCEPTION;
94: RAISE;
95: WHEN OTHERS THEN
96: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
97: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
98: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
99: fnd_message.set_token('AZW_ERROR_PROC','azw_group.contains_processes');
100: fnd_message.set_token('AZW_ERROR_STMT','CURSOR sub_group_c');
101: APP_EXCEPTION.RAISE_EXCEPTION;
102: END contains_processes;
95: WHEN OTHERS THEN
96: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
97: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
98: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
99: fnd_message.set_token('AZW_ERROR_PROC','azw_group.contains_processes');
100: fnd_message.set_token('AZW_ERROR_STMT','CURSOR sub_group_c');
101: APP_EXCEPTION.RAISE_EXCEPTION;
102: END contains_processes;
103:
96: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
97: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
98: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
99: fnd_message.set_token('AZW_ERROR_PROC','azw_group.contains_processes');
100: fnd_message.set_token('AZW_ERROR_STMT','CURSOR sub_group_c');
101: APP_EXCEPTION.RAISE_EXCEPTION;
102: END contains_processes;
103:
104: FUNCTION get_installed_flag(appl_id NUMBER) RETURN VARCHAR2 IS
142: v_installed_flag := 'A';
143: RETURN v_installed_flag;
144: WHEN OTHERS THEN
145: -- DBMS_OUTPUT.PUT_LINE('error: get_installed_flag: ' || SQLERRM);
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_group.get_installed_flag');
150: fnd_message.set_token('AZW_ERROR_STMT','select status from fnd_product_installations,fnd_application_vl');
143: RETURN v_installed_flag;
144: WHEN OTHERS THEN
145: -- DBMS_OUTPUT.PUT_LINE('error: get_installed_flag: ' || SQLERRM);
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_group.get_installed_flag');
150: fnd_message.set_token('AZW_ERROR_STMT','select status from fnd_product_installations,fnd_application_vl');
151: APP_EXCEPTION.RAISE_EXCEPTION;
144: WHEN OTHERS THEN
145: -- DBMS_OUTPUT.PUT_LINE('error: get_installed_flag: ' || SQLERRM);
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_group.get_installed_flag');
150: fnd_message.set_token('AZW_ERROR_STMT','select status from fnd_product_installations,fnd_application_vl');
151: APP_EXCEPTION.RAISE_EXCEPTION;
152: END get_installed_flag;
145: -- DBMS_OUTPUT.PUT_LINE('error: get_installed_flag: ' || SQLERRM);
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_group.get_installed_flag');
150: fnd_message.set_token('AZW_ERROR_STMT','select status from fnd_product_installations,fnd_application_vl');
151: APP_EXCEPTION.RAISE_EXCEPTION;
152: END get_installed_flag;
153:
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_group.get_installed_flag');
150: fnd_message.set_token('AZW_ERROR_STMT','select status from fnd_product_installations,fnd_application_vl');
151: APP_EXCEPTION.RAISE_EXCEPTION;
152: END get_installed_flag;
153:
154:
188: v_installed_flag := 'A';
189: RETURN v_installed_flag;
190: WHEN OTHERS THEN
191: --DBMS_OUTPUT.PUT_LINE('error: get_installed_flag: ' || SQLERRM);
192: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
193: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
194: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
195: fnd_message.set_token('AZW_ERROR_PROC','azw_group.get_process');
196: fnd_message.set_token('AZW_ERROR_STMT','CURSOR process_hierarchy_pn');
189: RETURN v_installed_flag;
190: WHEN OTHERS THEN
191: --DBMS_OUTPUT.PUT_LINE('error: get_installed_flag: ' || SQLERRM);
192: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
193: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
194: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
195: fnd_message.set_token('AZW_ERROR_PROC','azw_group.get_process');
196: fnd_message.set_token('AZW_ERROR_STMT','CURSOR process_hierarchy_pn');
197: APP_EXCEPTION.RAISE_EXCEPTION;
190: WHEN OTHERS THEN
191: --DBMS_OUTPUT.PUT_LINE('error: get_installed_flag: ' || SQLERRM);
192: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
193: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
194: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
195: fnd_message.set_token('AZW_ERROR_PROC','azw_group.get_process');
196: fnd_message.set_token('AZW_ERROR_STMT','CURSOR process_hierarchy_pn');
197: APP_EXCEPTION.RAISE_EXCEPTION;
198: END get_installed_flag_group;
191: --DBMS_OUTPUT.PUT_LINE('error: get_installed_flag: ' || SQLERRM);
192: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
193: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
194: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
195: fnd_message.set_token('AZW_ERROR_PROC','azw_group.get_process');
196: fnd_message.set_token('AZW_ERROR_STMT','CURSOR process_hierarchy_pn');
197: APP_EXCEPTION.RAISE_EXCEPTION;
198: END get_installed_flag_group;
199:
192: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
193: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
194: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
195: fnd_message.set_token('AZW_ERROR_PROC','azw_group.get_process');
196: fnd_message.set_token('AZW_ERROR_STMT','CURSOR process_hierarchy_pn');
197: APP_EXCEPTION.RAISE_EXCEPTION;
198: END get_installed_flag_group;
199:
200:
287: WHEN app_exception.application_exception THEN
288: RAISE;
289: WHEN OTHERS THEN
290: -- DBMS_OUTPUT.PUT_LINE('error: get_group_dependency: ' || SQLERRM);
291: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
292: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
293: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
294: fnd_message.set_token('AZW_ERROR_PROC','azw_group.get_group_dependency');
295: fnd_message.set_token('AZW_ERROR_STMT','CURSOR dependency_cursor');
288: RAISE;
289: WHEN OTHERS THEN
290: -- DBMS_OUTPUT.PUT_LINE('error: get_group_dependency: ' || SQLERRM);
291: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
292: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
293: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
294: fnd_message.set_token('AZW_ERROR_PROC','azw_group.get_group_dependency');
295: fnd_message.set_token('AZW_ERROR_STMT','CURSOR dependency_cursor');
296: APP_EXCEPTION.RAISE_EXCEPTION;
289: WHEN OTHERS THEN
290: -- DBMS_OUTPUT.PUT_LINE('error: get_group_dependency: ' || SQLERRM);
291: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
292: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
293: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
294: fnd_message.set_token('AZW_ERROR_PROC','azw_group.get_group_dependency');
295: fnd_message.set_token('AZW_ERROR_STMT','CURSOR dependency_cursor');
296: APP_EXCEPTION.RAISE_EXCEPTION;
297: END get_group_dependency;
290: -- DBMS_OUTPUT.PUT_LINE('error: get_group_dependency: ' || SQLERRM);
291: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
292: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
293: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
294: fnd_message.set_token('AZW_ERROR_PROC','azw_group.get_group_dependency');
295: fnd_message.set_token('AZW_ERROR_STMT','CURSOR dependency_cursor');
296: APP_EXCEPTION.RAISE_EXCEPTION;
297: END get_group_dependency;
298:
291: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
292: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
293: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
294: fnd_message.set_token('AZW_ERROR_PROC','azw_group.get_group_dependency');
295: fnd_message.set_token('AZW_ERROR_STMT','CURSOR dependency_cursor');
296: APP_EXCEPTION.RAISE_EXCEPTION;
297: END get_group_dependency;
298:
299:
340: EXCEPTION
341: WHEN app_exception.application_exception THEN
342: RAISE;
343: WHEN OTHERS THEN
344: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
345: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
346: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
347: fnd_message.set_token('AZW_ERROR_PROC','azw_group.get_dependency');
348: fnd_message.set_token('AZW_ERROR_STMT','insert into az_webform_messages');
341: WHEN app_exception.application_exception THEN
342: RAISE;
343: WHEN OTHERS THEN
344: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
345: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
346: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
347: fnd_message.set_token('AZW_ERROR_PROC','azw_group.get_dependency');
348: fnd_message.set_token('AZW_ERROR_STMT','insert into az_webform_messages');
349: APP_EXCEPTION.RAISE_EXCEPTION;
342: RAISE;
343: WHEN OTHERS THEN
344: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
345: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
346: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
347: fnd_message.set_token('AZW_ERROR_PROC','azw_group.get_dependency');
348: fnd_message.set_token('AZW_ERROR_STMT','insert into az_webform_messages');
349: APP_EXCEPTION.RAISE_EXCEPTION;
350: END;
343: WHEN OTHERS THEN
344: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
345: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
346: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
347: fnd_message.set_token('AZW_ERROR_PROC','azw_group.get_dependency');
348: fnd_message.set_token('AZW_ERROR_STMT','insert into az_webform_messages');
349: APP_EXCEPTION.RAISE_EXCEPTION;
350: END;
351:
344: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
345: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
346: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
347: fnd_message.set_token('AZW_ERROR_PROC','azw_group.get_dependency');
348: fnd_message.set_token('AZW_ERROR_STMT','insert into az_webform_messages');
349: APP_EXCEPTION.RAISE_EXCEPTION;
350: END;
351:
352: END IF;
356: WHEN app_exception.application_exception THEN
357: APP_EXCEPTION.RAISE_EXCEPTION;
358: WHEN OTHERS THEN
359: --DBMS_OUTPUT.PUT_LINE('error: get_dependency: ' || SQLERRM);
360: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
361: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
362: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
363: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_dependency');
364: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
357: APP_EXCEPTION.RAISE_EXCEPTION;
358: WHEN OTHERS THEN
359: --DBMS_OUTPUT.PUT_LINE('error: get_dependency: ' || SQLERRM);
360: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
361: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
362: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
363: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_dependency');
364: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
365: APP_EXCEPTION.RAISE_EXCEPTION;
358: WHEN OTHERS THEN
359: --DBMS_OUTPUT.PUT_LINE('error: get_dependency: ' || SQLERRM);
360: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
361: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
362: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
363: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_dependency');
364: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
365: APP_EXCEPTION.RAISE_EXCEPTION;
366: END get_dependency;
359: --DBMS_OUTPUT.PUT_LINE('error: get_dependency: ' || SQLERRM);
360: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
361: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
362: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
363: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_dependency');
364: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
365: APP_EXCEPTION.RAISE_EXCEPTION;
366: END get_dependency;
367:
360: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
361: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
362: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
363: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_dependency');
364: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
365: APP_EXCEPTION.RAISE_EXCEPTION;
366: END get_dependency;
367:
368: END AZW_GROUP;