DBA Data[Home] [Help]

APPS.AZW_GROUP dependencies on FND_MESSAGE

Line 52: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

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

Line 53: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

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;

Line 54: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);

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;

Line 55: fnd_message.set_token('AZW_ERROR_PROC','azw_group.contains_processes');

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:

Line 56: fnd_message.set_token('AZW_ERROR_STMT','select count(*) into child_count from az_processes');

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

Line 81: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

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

Line 82: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

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;

Line 83: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);

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;

Line 84: fnd_message.set_token('AZW_ERROR_PROC','azw_group.contains_processes');

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;

Line 85: fnd_message.set_token('AZW_ERROR_STMT','CURSOR sub_group_c');

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:

Line 96: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

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

Line 97: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

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;

Line 98: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);

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;

Line 99: fnd_message.set_token('AZW_ERROR_PROC','azw_group.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:

Line 100: fnd_message.set_token('AZW_ERROR_STMT','CURSOR sub_group_c');

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

Line 146: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

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

Line 147: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

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;

Line 148: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);

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;

Line 149: fnd_message.set_token('AZW_ERROR_PROC','azw_group.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:

Line 150: fnd_message.set_token('AZW_ERROR_STMT','select status from fnd_product_installations,fnd_application_vl');

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:

Line 192: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

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

Line 193: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

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;

Line 194: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);

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;

Line 195: fnd_message.set_token('AZW_ERROR_PROC','azw_group.get_process');

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:

Line 196: fnd_message.set_token('AZW_ERROR_STMT','CURSOR process_hierarchy_pn');

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:

Line 291: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

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

Line 292: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

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;

Line 293: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);

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;

Line 294: fnd_message.set_token('AZW_ERROR_PROC','azw_group.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:

Line 295: fnd_message.set_token('AZW_ERROR_STMT','CURSOR dependency_cursor');

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:

Line 344: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

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

Line 345: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

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;

Line 346: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);

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;

Line 347: fnd_message.set_token('AZW_ERROR_PROC','azw_group.get_dependency');

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:

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

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;

Line 360: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

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

Line 361: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

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;

Line 362: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);

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;

Line 363: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.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:

Line 364: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');

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;