DBA Data[Home] [Help]

APPS.AZW_UTIL dependencies on FND_MESSAGE

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

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

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

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;

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

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;

Line 57: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');

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:

Line 58: fnd_message.set_token('AZW_ERROR_STMT','select process_version from wf_process_activities');

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;

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

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

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

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;

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

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;

Line 78: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');

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:

Line 79: fnd_message.set_token('AZW_ERROR_STMT','select type from wf_activities');

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

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

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

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

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;

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

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;

Line 97: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');

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:

Line 98: fnd_message.set_token('AZW_ERROR_STMT','select message from wf_activities');

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

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

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

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

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;

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

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;

Line 113: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');

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:

Line 114: fnd_message.set_token('AZW_ERROR_STMT','cursor c_apps_c');

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

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

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

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

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;

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

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;

Line 129: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');

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:

Line 130: fnd_message.set_token('AZW_ERROR_STMT','cursor c_target_c');

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

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

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

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

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;

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

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;

Line 149: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');

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;

Line 150: fnd_message.set_token('AZW_ERROR_STMT','update wf_message_attribute');

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:

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

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

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

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;

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

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;

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

Line 167: fnd_message.set_token('AZW_ERROR_STMT','cursor c_act_c');

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

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

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

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

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;

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

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;

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

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

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

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

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

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

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;

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

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:

Line 346: fnd_message.set_token('AZW_ERROR_PROC','azw_util.validate_opm_context');

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;

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

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:

Line 462: fnd_message.set_name('AZ', 'AZW_INCORRECT_CONTEXT_SOB');

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

Line 464: fnd_message.set_name('AZ', 'AZW_INCORRECT_CONTEXT_OU');

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

Line 466: fnd_message.set_name('AZ', 'AZW_INCORRECT_CONTEXT_BG');

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

Line 468: fnd_message.set_name('AZ', 'AZW_INCORRECT_CONTEXT_INV');

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

Line 470: fnd_message.set_name('AZ', 'AZW_INCORRECT_CONTEXT_OPMCOM');

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

Line 472: fnd_message.set_name('AZ', 'AZW_INCORRECT_CONTEXT_OPMORG');

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

Line 474: fnd_message.set_token('AZWCURTYPE', 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;

Line 475: fnd_message.set_token('AZWCURCTXT', context);

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:

Line 476: fnd_message.set_token('AZWDESTYPE', context_type);

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;

Line 477: fnd_message.set_token('AZWDESCTXT', context_name);

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:

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

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

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

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;

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

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;

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

Line 507: fnd_message.set_token('AZW_ERROR_STMT','Call to CheckContext');

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