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_GROUP dependencies on APP_EXCEPTION

Line 49: WHEN app_exception.application_exception THEN

45: FROM az_processes azp
46: WHERE azp.parent_id = node_id
47: AND azp.process_type = g_current_mode ;
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);

Line 57: APP_EXCEPTION.RAISE_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);
61: IF child_count > 0 THEN

Line 78: WHEN app_exception.application_exception THEN

74: END LOOP;
75: <>
76: CLOSE sub_group_c;
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);

Line 86: APP_EXCEPTION.RAISE_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:
90: RETURN ret_val;

Line 93: WHEN app_exception.application_exception THEN

89:
90: RETURN ret_val;
91:
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);

Line 101: APP_EXCEPTION.RAISE_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
105: v_installed_flag VARCHAR2(1) DEFAULT 'A';

Line 139: WHEN app_exception.application_exception THEN

135:
136: RETURN v_installed_flag;
137:
138: EXCEPTION
139: WHEN app_exception.application_exception THEN
140: RAISE;
141: WHEN NO_DATA_FOUND THEN
142: v_installed_flag := 'A';
143: RETURN v_installed_flag;

Line 151: APP_EXCEPTION.RAISE_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:
155: --

Line 185: WHEN app_exception.application_exception THEN

181:
182: RETURN v_installed_flag;
183:
184: EXCEPTION
185: WHEN app_exception.application_exception THEN
186: RAISE;
187: WHEN NO_DATA_FOUND THEN
188: v_installed_flag := 'A';
189: RETURN v_installed_flag;

Line 197: APP_EXCEPTION.RAISE_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:
201: --

Line 287: WHEN app_exception.application_exception THEN

283: END LOOP;
284: CLOSE dependency_cursor;
285:
286: 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');

Line 296: APP_EXCEPTION.RAISE_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:
300: --

Line 341: WHEN app_exception.application_exception THEN

337:
338: INSERT INTO az_webform_messages (mesg)
339: VALUES (mesg);
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);

Line 349: APP_EXCEPTION.RAISE_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;
353: END LOOP;

Line 356: WHEN app_exception.application_exception THEN

352: END IF;
353: END LOOP;
354:
355: 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');

Line 357: APP_EXCEPTION.RAISE_EXCEPTION;

353: END LOOP;
354:
355: 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);

Line 365: APP_EXCEPTION.RAISE_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;