50: EXCEPTION
51: WHEN app_exception.application_exception THEN
52: RAISE ;
53: WHEN OTHERS THEN
54: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
55: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
56: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
57: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');
58: fnd_message.set_token('AZW_ERROR_STMT','select process_version from wf_process_activities');
51: WHEN app_exception.application_exception THEN
52: RAISE ;
53: WHEN OTHERS THEN
54: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
55: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
56: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
57: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');
58: fnd_message.set_token('AZW_ERROR_STMT','select process_version from wf_process_activities');
59: APP_EXCEPTION.RAISE_EXCEPTION;
52: RAISE ;
53: WHEN OTHERS THEN
54: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
55: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
56: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
57: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');
58: fnd_message.set_token('AZW_ERROR_STMT','select process_version from wf_process_activities');
59: APP_EXCEPTION.RAISE_EXCEPTION;
60: END;
53: WHEN OTHERS THEN
54: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
55: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
56: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
57: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');
58: fnd_message.set_token('AZW_ERROR_STMT','select process_version from wf_process_activities');
59: APP_EXCEPTION.RAISE_EXCEPTION;
60: END;
61:
54: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
55: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
56: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
57: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');
58: fnd_message.set_token('AZW_ERROR_STMT','select process_version from wf_process_activities');
59: APP_EXCEPTION.RAISE_EXCEPTION;
60: END;
61:
62: OPEN c_act_c;
71: EXCEPTION
72: WHEN app_exception.application_exception THEN
73: RAISE ;
74: WHEN OTHERS THEN
75: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
76: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
77: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
78: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');
79: fnd_message.set_token('AZW_ERROR_STMT','select type from wf_activities');
72: WHEN app_exception.application_exception THEN
73: RAISE ;
74: WHEN OTHERS THEN
75: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
76: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
77: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
78: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');
79: fnd_message.set_token('AZW_ERROR_STMT','select type from wf_activities');
80: APP_EXCEPTION.RAISE_EXCEPTION;
73: RAISE ;
74: WHEN OTHERS THEN
75: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
76: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
77: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
78: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');
79: fnd_message.set_token('AZW_ERROR_STMT','select type from wf_activities');
80: APP_EXCEPTION.RAISE_EXCEPTION;
81: END;
74: WHEN OTHERS THEN
75: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
76: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
77: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
78: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');
79: fnd_message.set_token('AZW_ERROR_STMT','select type from wf_activities');
80: APP_EXCEPTION.RAISE_EXCEPTION;
81: END;
82:
75: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
76: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
77: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
78: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');
79: fnd_message.set_token('AZW_ERROR_STMT','select type from wf_activities');
80: APP_EXCEPTION.RAISE_EXCEPTION;
81: END;
82:
83: if (act_type = 'NOTICE') then
90: EXCEPTION
91: WHEN app_exception.application_exception THEN
92: RAISE ;
93: WHEN OTHERS THEN
94: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
95: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
96: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
97: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');
98: fnd_message.set_token('AZW_ERROR_STMT','select message from wf_activities');
91: WHEN app_exception.application_exception THEN
92: RAISE ;
93: WHEN OTHERS THEN
94: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
95: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
96: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
97: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');
98: fnd_message.set_token('AZW_ERROR_STMT','select message from wf_activities');
99: APP_EXCEPTION.RAISE_EXCEPTION;
92: RAISE ;
93: WHEN OTHERS THEN
94: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
95: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
96: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
97: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');
98: fnd_message.set_token('AZW_ERROR_STMT','select message from wf_activities');
99: APP_EXCEPTION.RAISE_EXCEPTION;
100: END;
93: WHEN OTHERS THEN
94: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
95: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
96: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
97: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');
98: fnd_message.set_token('AZW_ERROR_STMT','select message from wf_activities');
99: APP_EXCEPTION.RAISE_EXCEPTION;
100: END;
101:
94: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
95: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
96: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
97: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');
98: fnd_message.set_token('AZW_ERROR_STMT','select message from wf_activities');
99: APP_EXCEPTION.RAISE_EXCEPTION;
100: END;
101:
102: BEGIN
106: EXCEPTION
107: WHEN app_exception.application_exception THEN
108: RAISE ;
109: WHEN OTHERS THEN
110: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
111: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
112: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
113: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');
114: fnd_message.set_token('AZW_ERROR_STMT','cursor c_apps_c');
107: WHEN app_exception.application_exception THEN
108: RAISE ;
109: WHEN OTHERS THEN
110: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
111: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
112: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
113: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');
114: fnd_message.set_token('AZW_ERROR_STMT','cursor c_apps_c');
115: APP_EXCEPTION.RAISE_EXCEPTION;
108: RAISE ;
109: WHEN OTHERS THEN
110: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
111: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
112: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
113: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');
114: fnd_message.set_token('AZW_ERROR_STMT','cursor c_apps_c');
115: APP_EXCEPTION.RAISE_EXCEPTION;
116: END;
109: WHEN OTHERS THEN
110: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
111: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
112: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
113: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');
114: fnd_message.set_token('AZW_ERROR_STMT','cursor c_apps_c');
115: APP_EXCEPTION.RAISE_EXCEPTION;
116: END;
117:
110: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
111: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
112: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
113: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');
114: fnd_message.set_token('AZW_ERROR_STMT','cursor c_apps_c');
115: APP_EXCEPTION.RAISE_EXCEPTION;
116: END;
117:
118: BEGIN
122: EXCEPTION
123: WHEN app_exception.application_exception THEN
124: RAISE ;
125: WHEN OTHERS THEN
126: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
127: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
128: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
129: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');
130: fnd_message.set_token('AZW_ERROR_STMT','cursor c_target_c');
123: WHEN app_exception.application_exception THEN
124: RAISE ;
125: WHEN OTHERS THEN
126: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
127: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
128: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
129: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');
130: fnd_message.set_token('AZW_ERROR_STMT','cursor c_target_c');
131: APP_EXCEPTION.RAISE_EXCEPTION;
124: RAISE ;
125: WHEN OTHERS THEN
126: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
127: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
128: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
129: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');
130: fnd_message.set_token('AZW_ERROR_STMT','cursor c_target_c');
131: APP_EXCEPTION.RAISE_EXCEPTION;
132: END;
125: WHEN OTHERS THEN
126: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
127: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
128: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
129: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');
130: fnd_message.set_token('AZW_ERROR_STMT','cursor c_target_c');
131: APP_EXCEPTION.RAISE_EXCEPTION;
132: END;
133:
126: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
127: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
128: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
129: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');
130: fnd_message.set_token('AZW_ERROR_STMT','cursor c_target_c');
131: APP_EXCEPTION.RAISE_EXCEPTION;
132: END;
133:
134: url := fnd_help.get_url(app_short_name, target);
142: EXCEPTION
143: WHEN app_exception.application_exception THEN
144: RAISE ;
145: WHEN OTHERS THEN
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_util.UpdateDocUrl');
150: fnd_message.set_token('AZW_ERROR_STMT','update wf_message_attribute');
143: WHEN app_exception.application_exception THEN
144: RAISE ;
145: WHEN OTHERS THEN
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_util.UpdateDocUrl');
150: fnd_message.set_token('AZW_ERROR_STMT','update wf_message_attribute');
151: APP_EXCEPTION.RAISE_EXCEPTION;
144: RAISE ;
145: WHEN OTHERS THEN
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_util.UpdateDocUrl');
150: fnd_message.set_token('AZW_ERROR_STMT','update wf_message_attribute');
151: APP_EXCEPTION.RAISE_EXCEPTION;
152: END;
145: WHEN OTHERS THEN
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_util.UpdateDocUrl');
150: fnd_message.set_token('AZW_ERROR_STMT','update wf_message_attribute');
151: APP_EXCEPTION.RAISE_EXCEPTION;
152: END;
153: end if;
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_util.UpdateDocUrl');
150: fnd_message.set_token('AZW_ERROR_STMT','update wf_message_attribute');
151: APP_EXCEPTION.RAISE_EXCEPTION;
152: END;
153: end if;
154:
159: EXCEPTION
160: WHEN app_exception.application_exception THEN
161: RAISE ;
162: WHEN OTHERS THEN
163: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
164: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
165: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
166: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');
167: fnd_message.set_token('AZW_ERROR_STMT','cursor c_act_c');
160: WHEN app_exception.application_exception THEN
161: RAISE ;
162: WHEN OTHERS THEN
163: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
164: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
165: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
166: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');
167: fnd_message.set_token('AZW_ERROR_STMT','cursor c_act_c');
168: APP_EXCEPTION.RAISE_EXCEPTION;
161: RAISE ;
162: WHEN OTHERS THEN
163: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
164: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
165: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
166: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');
167: fnd_message.set_token('AZW_ERROR_STMT','cursor c_act_c');
168: APP_EXCEPTION.RAISE_EXCEPTION;
169: End UpdateDocUrl;
162: WHEN OTHERS THEN
163: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
164: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
165: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
166: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');
167: fnd_message.set_token('AZW_ERROR_STMT','cursor c_act_c');
168: APP_EXCEPTION.RAISE_EXCEPTION;
169: End UpdateDocUrl;
170:
163: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
164: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
165: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
166: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');
167: fnd_message.set_token('AZW_ERROR_STMT','cursor c_act_c');
168: APP_EXCEPTION.RAISE_EXCEPTION;
169: End UpdateDocUrl;
170:
171: -- IsProductInstalled
202: EXCEPTION
203: WHEN app_exception.application_exception THEN
204: RAISE ;
205: WHEN OTHERS THEN
206: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
207: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
208: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
209: fnd_message.set_token('AZW_ERROR_PROC','azw_util.IsProductInstalled');
210: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
203: WHEN app_exception.application_exception THEN
204: RAISE ;
205: WHEN OTHERS THEN
206: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
207: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
208: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
209: fnd_message.set_token('AZW_ERROR_PROC','azw_util.IsProductInstalled');
210: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
211: APP_EXCEPTION.RAISE_EXCEPTION;
204: RAISE ;
205: WHEN OTHERS THEN
206: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
207: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
208: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
209: fnd_message.set_token('AZW_ERROR_PROC','azw_util.IsProductInstalled');
210: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
211: APP_EXCEPTION.RAISE_EXCEPTION;
212: END IsProductInstalled;
205: WHEN OTHERS THEN
206: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
207: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
208: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
209: fnd_message.set_token('AZW_ERROR_PROC','azw_util.IsProductInstalled');
210: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
211: APP_EXCEPTION.RAISE_EXCEPTION;
212: END IsProductInstalled;
213:
206: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
207: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
208: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
209: fnd_message.set_token('AZW_ERROR_PROC','azw_util.IsProductInstalled');
210: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
211: APP_EXCEPTION.RAISE_EXCEPTION;
212: END IsProductInstalled;
213:
214: -- CheckProduct
339: IF DBMS_SQL.IS_OPEN(curs) then
340: DBMS_SQL.CLOSE_CURSOR(curs);
341: END IF;
342:
343: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
344: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
345: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
346: fnd_message.set_token('AZW_ERROR_PROC','azw_util.validate_opm_context');
347: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
340: DBMS_SQL.CLOSE_CURSOR(curs);
341: END IF;
342:
343: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
344: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
345: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
346: fnd_message.set_token('AZW_ERROR_PROC','azw_util.validate_opm_context');
347: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
348: APP_EXCEPTION.RAISE_EXCEPTION;
341: END IF;
342:
343: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
344: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
345: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
346: fnd_message.set_token('AZW_ERROR_PROC','azw_util.validate_opm_context');
347: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
348: APP_EXCEPTION.RAISE_EXCEPTION;
349:
342:
343: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
344: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
345: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
346: fnd_message.set_token('AZW_ERROR_PROC','azw_util.validate_opm_context');
347: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
348: APP_EXCEPTION.RAISE_EXCEPTION;
349:
350: END validate_opm_context;
343: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
344: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
345: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
346: fnd_message.set_token('AZW_ERROR_PROC','azw_util.validate_opm_context');
347: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
348: APP_EXCEPTION.RAISE_EXCEPTION;
349:
350: END validate_opm_context;
351:
458: return;
459: end if;
460:
461: if (context_type = 'SOB') then
462: fnd_message.set_name('AZ', 'AZW_INCORRECT_CONTEXT_SOB');
463: elsif (context_type = 'OU') then
464: fnd_message.set_name('AZ', 'AZW_INCORRECT_CONTEXT_OU');
465: elsif (context_type = 'BG') then
466: fnd_message.set_name('AZ', 'AZW_INCORRECT_CONTEXT_BG');
460:
461: if (context_type = 'SOB') then
462: fnd_message.set_name('AZ', 'AZW_INCORRECT_CONTEXT_SOB');
463: elsif (context_type = 'OU') then
464: fnd_message.set_name('AZ', 'AZW_INCORRECT_CONTEXT_OU');
465: elsif (context_type = 'BG') then
466: fnd_message.set_name('AZ', 'AZW_INCORRECT_CONTEXT_BG');
467: elsif (context_type = 'IO') then
468: fnd_message.set_name('AZ', 'AZW_INCORRECT_CONTEXT_INV');
462: fnd_message.set_name('AZ', 'AZW_INCORRECT_CONTEXT_SOB');
463: elsif (context_type = 'OU') then
464: fnd_message.set_name('AZ', 'AZW_INCORRECT_CONTEXT_OU');
465: elsif (context_type = 'BG') then
466: fnd_message.set_name('AZ', 'AZW_INCORRECT_CONTEXT_BG');
467: elsif (context_type = 'IO') then
468: fnd_message.set_name('AZ', 'AZW_INCORRECT_CONTEXT_INV');
469: elsif (context_type = 'OPMCOM') then
470: fnd_message.set_name('AZ', 'AZW_INCORRECT_CONTEXT_OPMCOM');
464: fnd_message.set_name('AZ', 'AZW_INCORRECT_CONTEXT_OU');
465: elsif (context_type = 'BG') then
466: fnd_message.set_name('AZ', 'AZW_INCORRECT_CONTEXT_BG');
467: elsif (context_type = 'IO') then
468: fnd_message.set_name('AZ', 'AZW_INCORRECT_CONTEXT_INV');
469: elsif (context_type = 'OPMCOM') then
470: fnd_message.set_name('AZ', 'AZW_INCORRECT_CONTEXT_OPMCOM');
471: elsif (context_type = 'OPMORG') then
472: fnd_message.set_name('AZ', 'AZW_INCORRECT_CONTEXT_OPMORG');
466: fnd_message.set_name('AZ', 'AZW_INCORRECT_CONTEXT_BG');
467: elsif (context_type = 'IO') then
468: fnd_message.set_name('AZ', 'AZW_INCORRECT_CONTEXT_INV');
469: elsif (context_type = 'OPMCOM') then
470: fnd_message.set_name('AZ', 'AZW_INCORRECT_CONTEXT_OPMCOM');
471: elsif (context_type = 'OPMORG') then
472: fnd_message.set_name('AZ', 'AZW_INCORRECT_CONTEXT_OPMORG');
473: end if;
474: fnd_message.set_token('AZWCURTYPE', context_type);
468: fnd_message.set_name('AZ', 'AZW_INCORRECT_CONTEXT_INV');
469: elsif (context_type = 'OPMCOM') then
470: fnd_message.set_name('AZ', 'AZW_INCORRECT_CONTEXT_OPMCOM');
471: elsif (context_type = 'OPMORG') then
472: fnd_message.set_name('AZ', 'AZW_INCORRECT_CONTEXT_OPMORG');
473: end if;
474: fnd_message.set_token('AZWCURTYPE', context_type);
475: fnd_message.set_token('AZWCURCTXT', context);
476: fnd_message.set_token('AZWDESTYPE', context_type);
470: fnd_message.set_name('AZ', 'AZW_INCORRECT_CONTEXT_OPMCOM');
471: elsif (context_type = 'OPMORG') then
472: fnd_message.set_name('AZ', 'AZW_INCORRECT_CONTEXT_OPMORG');
473: end if;
474: fnd_message.set_token('AZWCURTYPE', context_type);
475: fnd_message.set_token('AZWCURCTXT', context);
476: fnd_message.set_token('AZWDESTYPE', context_type);
477: fnd_message.set_token('AZWDESCTXT', context_name);
478: APP_EXCEPTION.RAISE_EXCEPTION;
471: elsif (context_type = 'OPMORG') then
472: fnd_message.set_name('AZ', 'AZW_INCORRECT_CONTEXT_OPMORG');
473: end if;
474: fnd_message.set_token('AZWCURTYPE', context_type);
475: fnd_message.set_token('AZWCURCTXT', context);
476: fnd_message.set_token('AZWDESTYPE', context_type);
477: fnd_message.set_token('AZWDESCTXT', context_name);
478: APP_EXCEPTION.RAISE_EXCEPTION;
479:
472: fnd_message.set_name('AZ', 'AZW_INCORRECT_CONTEXT_OPMORG');
473: end if;
474: fnd_message.set_token('AZWCURTYPE', context_type);
475: fnd_message.set_token('AZWCURCTXT', context);
476: fnd_message.set_token('AZWDESTYPE', context_type);
477: fnd_message.set_token('AZWDESCTXT', context_name);
478: APP_EXCEPTION.RAISE_EXCEPTION;
479:
480: END CheckContext;
473: end if;
474: fnd_message.set_token('AZWCURTYPE', context_type);
475: fnd_message.set_token('AZWCURCTXT', context);
476: fnd_message.set_token('AZWDESTYPE', context_type);
477: fnd_message.set_token('AZWDESCTXT', context_name);
478: APP_EXCEPTION.RAISE_EXCEPTION;
479:
480: END CheckContext;
481:
499: EXCEPTION
500: WHEN app_exception.application_exception THEN
501: RAISE ;
502: WHEN OTHERS THEN
503: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
504: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
505: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
506: fnd_message.set_token('AZW_ERROR_PROC','azw_util.Callback');
507: fnd_message.set_token('AZW_ERROR_STMT','Call to CheckContext');
500: WHEN app_exception.application_exception THEN
501: RAISE ;
502: WHEN OTHERS THEN
503: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
504: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
505: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
506: fnd_message.set_token('AZW_ERROR_PROC','azw_util.Callback');
507: fnd_message.set_token('AZW_ERROR_STMT','Call to CheckContext');
508: APP_EXCEPTION.RAISE_EXCEPTION;
501: RAISE ;
502: WHEN OTHERS THEN
503: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
504: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
505: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
506: fnd_message.set_token('AZW_ERROR_PROC','azw_util.Callback');
507: fnd_message.set_token('AZW_ERROR_STMT','Call to CheckContext');
508: APP_EXCEPTION.RAISE_EXCEPTION;
509: END Callback;
502: WHEN OTHERS THEN
503: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
504: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
505: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
506: fnd_message.set_token('AZW_ERROR_PROC','azw_util.Callback');
507: fnd_message.set_token('AZW_ERROR_STMT','Call to CheckContext');
508: APP_EXCEPTION.RAISE_EXCEPTION;
509: END Callback;
510:
503: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
504: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
505: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
506: fnd_message.set_token('AZW_ERROR_PROC','azw_util.Callback');
507: fnd_message.set_token('AZW_ERROR_STMT','Call to CheckContext');
508: APP_EXCEPTION.RAISE_EXCEPTION;
509: END Callback;
510:
511: -- PreviousStep