54:
55: l_exists := check_exists(p_msg_code) ;
56:
57: IF (l_exists <> 0) THEN
58: fnd_message.set_name('XNP', 'DUPLICATE_OBJECT');
59: fnd_message.set_token('NAME',p_msg_code);
60: x_error_message := fnd_message.get ;
61: x_error_code := xnp_errors.g_duplicate_object;
62: RETURN ;
55: l_exists := check_exists(p_msg_code) ;
56:
57: IF (l_exists <> 0) THEN
58: fnd_message.set_name('XNP', 'DUPLICATE_OBJECT');
59: fnd_message.set_token('NAME',p_msg_code);
60: x_error_message := fnd_message.get ;
61: x_error_code := xnp_errors.g_duplicate_object;
62: RETURN ;
63: END IF ;
56:
57: IF (l_exists <> 0) THEN
58: fnd_message.set_name('XNP', 'DUPLICATE_OBJECT');
59: fnd_message.set_token('NAME',p_msg_code);
60: x_error_message := fnd_message.get ;
61: x_error_code := xnp_errors.g_duplicate_object;
62: RETURN ;
63: END IF ;
64:
83: -- No data source has been defined for the leaf element
84: -- But the Message code element is an exception
85:
86: IF (rec.name <> p_msg_code) THEN
87: fnd_message.set_name ('XNP','NO_DATA_SOURCE') ;
88: fnd_message.set_token ('NAME',rec.name) ;
89: x_error_message := fnd_message.get;
90: x_error_code := xnp_errors.g_no_data_source;
91: RETURN;
84: -- But the Message code element is an exception
85:
86: IF (rec.name <> p_msg_code) THEN
87: fnd_message.set_name ('XNP','NO_DATA_SOURCE') ;
88: fnd_message.set_token ('NAME',rec.name) ;
89: x_error_message := fnd_message.get;
90: x_error_code := xnp_errors.g_no_data_source;
91: RETURN;
92: END IF;
85:
86: IF (rec.name <> p_msg_code) THEN
87: fnd_message.set_name ('XNP','NO_DATA_SOURCE') ;
88: fnd_message.set_token ('NAME',rec.name) ;
89: x_error_message := fnd_message.get;
90: x_error_code := xnp_errors.g_no_data_source;
91: RETURN;
92: END IF;
93:
141: x_error_message := NULL;
142:
143: IF (p_source_type = 'SQL') THEN
144: IF (p_data_source IS NULL) THEN
145: fnd_message.set_name('XNP', 'NULL_SQL_SOURCE');
146: fnd_message.set_token('NAME', p_element_name);
147: x_error_message := fnd_message.get ;
148: x_error_code := xnp_errors.g_null_sql_source;
149: RETURN;
142:
143: IF (p_source_type = 'SQL') THEN
144: IF (p_data_source IS NULL) THEN
145: fnd_message.set_name('XNP', 'NULL_SQL_SOURCE');
146: fnd_message.set_token('NAME', p_element_name);
147: x_error_message := fnd_message.get ;
148: x_error_code := xnp_errors.g_null_sql_source;
149: RETURN;
150: END IF;
143: IF (p_source_type = 'SQL') THEN
144: IF (p_data_source IS NULL) THEN
145: fnd_message.set_name('XNP', 'NULL_SQL_SOURCE');
146: fnd_message.set_token('NAME', p_element_name);
147: x_error_message := fnd_message.get ;
148: x_error_code := xnp_errors.g_null_sql_source;
149: RETURN;
150: END IF;
151:
155:
156: l_exists := INSTR(l_data_source, ';') ;
157:
158: IF (l_exists <> 0) THEN
159: fnd_message.set_name('XNP', 'SEMI_COLON_ERROR');
160: x_error_message := fnd_message.get ;
161: x_error_code := xnp_errors.g_semi_colon_error;
162: RETURN;
163: END IF;
156: l_exists := INSTR(l_data_source, ';') ;
157:
158: IF (l_exists <> 0) THEN
159: fnd_message.set_name('XNP', 'SEMI_COLON_ERROR');
160: x_error_message := fnd_message.get ;
161: x_error_code := xnp_errors.g_semi_colon_error;
162: RETURN;
163: END IF;
164:
166:
167: l_parent := check_if_parent(p_element_id) ;
168:
169: IF (l_parent = 0) AND (p_data_ref IS NULL) THEN
170: fnd_message.set_name('XNP', 'NO_DATA_REFERENCE');
171: fnd_message.set_token('NAME',p_element_name) ;
172: x_error_message := fnd_message.get ;
173: x_error_code := xnp_errors.g_no_data_reference;
174: RETURN;
167: l_parent := check_if_parent(p_element_id) ;
168:
169: IF (l_parent = 0) AND (p_data_ref IS NULL) THEN
170: fnd_message.set_name('XNP', 'NO_DATA_REFERENCE');
171: fnd_message.set_token('NAME',p_element_name) ;
172: x_error_message := fnd_message.get ;
173: x_error_code := xnp_errors.g_no_data_reference;
174: RETURN;
175: END IF;
168:
169: IF (l_parent = 0) AND (p_data_ref IS NULL) THEN
170: fnd_message.set_name('XNP', 'NO_DATA_REFERENCE');
171: fnd_message.set_token('NAME',p_element_name) ;
172: x_error_message := fnd_message.get ;
173: x_error_code := xnp_errors.g_no_data_reference;
174: RETURN;
175: END IF;
176:
180:
181: -- check if procedure name is defined
182:
183: IF (p_data_ref IS NULL) THEN
184: fnd_message.set_name('XNP', 'UNDEFINED_FUNCTION');
185: fnd_message.set_token('NAME', p_element_name);
186: x_error_message := fnd_message.get ;
187: x_error_code := xnp_errors.g_undefined_function;
188: RETURN;
181: -- check if procedure name is defined
182:
183: IF (p_data_ref IS NULL) THEN
184: fnd_message.set_name('XNP', 'UNDEFINED_FUNCTION');
185: fnd_message.set_token('NAME', p_element_name);
186: x_error_message := fnd_message.get ;
187: x_error_code := xnp_errors.g_undefined_function;
188: RETURN;
189: END IF;
182:
183: IF (p_data_ref IS NULL) THEN
184: fnd_message.set_name('XNP', 'UNDEFINED_FUNCTION');
185: fnd_message.set_token('NAME', p_element_name);
186: x_error_message := fnd_message.get ;
187: x_error_code := xnp_errors.g_undefined_function;
188: RETURN;
189: END IF;
190:
198: p_element_name => p_element_name,
199: p_reference => p_data_ref) ;
200:
201: IF (l_exists = 0) THEN
202: fnd_message.set_name('XNP', 'UNDEFINED_WI_PARAMETER');
203: IF (p_data_ref IS NULL) THEN
204: fnd_message.set_token('NAME',p_element_name);
205: ELSE
206: fnd_message.set_token('NAME',p_data_ref);
200:
201: IF (l_exists = 0) THEN
202: fnd_message.set_name('XNP', 'UNDEFINED_WI_PARAMETER');
203: IF (p_data_ref IS NULL) THEN
204: fnd_message.set_token('NAME',p_element_name);
205: ELSE
206: fnd_message.set_token('NAME',p_data_ref);
207: END IF;
208: x_error_message := fnd_message.get ;
202: fnd_message.set_name('XNP', 'UNDEFINED_WI_PARAMETER');
203: IF (p_data_ref IS NULL) THEN
204: fnd_message.set_token('NAME',p_element_name);
205: ELSE
206: fnd_message.set_token('NAME',p_data_ref);
207: END IF;
208: x_error_message := fnd_message.get ;
209: x_error_code := xnp_errors.g_undefined_wi_parameter;
210: RETURN;
204: fnd_message.set_token('NAME',p_element_name);
205: ELSE
206: fnd_message.set_token('NAME',p_data_ref);
207: END IF;
208: x_error_message := fnd_message.get ;
209: x_error_code := xnp_errors.g_undefined_wi_parameter;
210: RETURN;
211: END IF;
212:
226: p_element_name => p_element_name,
227: p_reference => p_data_ref) ;
228:
229: IF (l_exists = 0) THEN
230: fnd_message.set_name('XNP', 'UNDEFINED_ORDER_PARAMETER');
231: IF (p_data_ref IS NULL) THEN
232: fnd_message.set_token('NAME',p_element_name);
233: ELSE
234: fnd_message.set_token('NAME',p_data_ref);
228:
229: IF (l_exists = 0) THEN
230: fnd_message.set_name('XNP', 'UNDEFINED_ORDER_PARAMETER');
231: IF (p_data_ref IS NULL) THEN
232: fnd_message.set_token('NAME',p_element_name);
233: ELSE
234: fnd_message.set_token('NAME',p_data_ref);
235: END IF;
236: x_error_message := fnd_message.get ;
230: fnd_message.set_name('XNP', 'UNDEFINED_ORDER_PARAMETER');
231: IF (p_data_ref IS NULL) THEN
232: fnd_message.set_token('NAME',p_element_name);
233: ELSE
234: fnd_message.set_token('NAME',p_data_ref);
235: END IF;
236: x_error_message := fnd_message.get ;
237: x_error_code := xnp_errors.g_undefined_order_parameter;
238: RETURN;
232: fnd_message.set_token('NAME',p_element_name);
233: ELSE
234: fnd_message.set_token('NAME',p_data_ref);
235: END IF;
236: x_error_message := fnd_message.get ;
237: x_error_code := xnp_errors.g_undefined_order_parameter;
238: RETURN;
239: END IF;
240: */
253: p_element_name => p_element_name,
254: p_reference => p_data_ref) ;
255:
256: IF (l_exists = 0) THEN
257: fnd_message.set_name('XNP', 'UNDEFINED_FA_PARAMETER');
258: IF (p_data_ref IS NULL) THEN
259: fnd_message.set_token('NAME',p_element_name);
260: ELSE
261: fnd_message.set_token('NAME',p_data_ref);
255:
256: IF (l_exists = 0) THEN
257: fnd_message.set_name('XNP', 'UNDEFINED_FA_PARAMETER');
258: IF (p_data_ref IS NULL) THEN
259: fnd_message.set_token('NAME',p_element_name);
260: ELSE
261: fnd_message.set_token('NAME',p_data_ref);
262: END IF;
263: x_error_message := fnd_message.get ;
257: fnd_message.set_name('XNP', 'UNDEFINED_FA_PARAMETER');
258: IF (p_data_ref IS NULL) THEN
259: fnd_message.set_token('NAME',p_element_name);
260: ELSE
261: fnd_message.set_token('NAME',p_data_ref);
262: END IF;
263: x_error_message := fnd_message.get ;
264: x_error_code := xnp_errors.g_undefined_fa_parameter;
265: RETURN;
259: fnd_message.set_token('NAME',p_element_name);
260: ELSE
261: fnd_message.set_token('NAME',p_data_ref);
262: END IF;
263: x_error_message := fnd_message.get ;
264: x_error_code := xnp_errors.g_undefined_fa_parameter;
265: RETURN;
266: END IF;
267: */