DBA Data[Home] [Help]

APPS.EAM_LINEAR_LOCATIONS_PUB dependencies on FND_MESSAGE

Line 148: fnd_message.set_name('EAM', 'EAM_INVALID_PARAMETER');

144: (SELECT 1 FROM mfg_lookups WHERE lookup_code = p_external_source_name
145: AND lookup_type = 'EAM_EXTERNAL_SOURCE_NAME');
146:
147: IF (l_count = 0) THEN
148: fnd_message.set_name('EAM', 'EAM_INVALID_PARAMETER');
149: fnd_message.set_token('NAME', 'p_external_source_name : ' || p_external_source_name);
150: fnd_msg_pub.add;
151: RAISE fnd_api.g_exc_error;
152: END IF;

Line 149: fnd_message.set_token('NAME', 'p_external_source_name : ' || p_external_source_name);

145: AND lookup_type = 'EAM_EXTERNAL_SOURCE_NAME');
146:
147: IF (l_count = 0) THEN
148: fnd_message.set_name('EAM', 'EAM_INVALID_PARAMETER');
149: fnd_message.set_token('NAME', 'p_external_source_name : ' || p_external_source_name);
150: fnd_msg_pub.add;
151: RAISE fnd_api.g_exc_error;
152: END IF;
153:

Line 156: fnd_message.set_name('EAM', 'EAM_INVALID_PARAMETER');

152: END IF;
153:
154: -- Validation of external_linear_id
155: IF (p_external_linear_id IS NULL) THEN
156: fnd_message.set_name('EAM', 'EAM_INVALID_PARAMETER');
157: fnd_message.set_token('NAME', 'p_external_linear_id : ' || p_external_linear_id);
158: fnd_msg_pub.add;
159: RAISE fnd_api.g_exc_error;
160: END IF;

Line 157: fnd_message.set_token('NAME', 'p_external_linear_id : ' || p_external_linear_id);

153:
154: -- Validation of external_linear_id
155: IF (p_external_linear_id IS NULL) THEN
156: fnd_message.set_name('EAM', 'EAM_INVALID_PARAMETER');
157: fnd_message.set_token('NAME', 'p_external_linear_id : ' || p_external_linear_id);
158: fnd_msg_pub.add;
159: RAISE fnd_api.g_exc_error;
160: END IF;
161:

Line 168: fnd_message.set_name('EAM', 'EAM_EXT_LINEAR_ID_EXISTS');

164: AND external_source_name = p_external_source_name
165: AND external_linear_type = p_external_linear_type);
166:
167: IF (l_count > 0) THEN
168: fnd_message.set_name('EAM', 'EAM_EXT_LINEAR_ID_EXISTS');
169: fnd_msg_pub.add;
170: RAISE fnd_api.g_exc_error;
171: END IF;
172:

Line 271: fnd_message.set_name('EAM', 'EAM_INVALID_PARAMETER');

267: SELECT count(*) INTO l_count FROM dual WHERE EXISTS
268: (SELECT 1 FROM eam_linear_locations WHERE eam_linear_id = p_eam_linear_id);
269:
270: IF (l_count = 0) THEN
271: fnd_message.set_name('EAM', 'EAM_INVALID_PARAMETER');
272: fnd_message.set_token('NAME', 'p_eam_linear_id : ' || p_eam_linear_id);
273: fnd_msg_pub.add;
274: RAISE fnd_api.g_exc_error;
275: END IF;

Line 272: fnd_message.set_token('NAME', 'p_eam_linear_id : ' || p_eam_linear_id);

268: (SELECT 1 FROM eam_linear_locations WHERE eam_linear_id = p_eam_linear_id);
269:
270: IF (l_count = 0) THEN
271: fnd_message.set_name('EAM', 'EAM_INVALID_PARAMETER');
272: fnd_message.set_token('NAME', 'p_eam_linear_id : ' || p_eam_linear_id);
273: fnd_msg_pub.add;
274: RAISE fnd_api.g_exc_error;
275: END IF;
276:

Line 283: fnd_message.set_name('EAM', 'EAM_INVALID_PARAMETER');

279: (SELECT 1 FROM mfg_lookups WHERE lookup_code = p_external_source_name
280: AND lookup_type = 'EAM_EXTERNAL_SOURCE_NAME');
281:
282: IF (l_count = 0) THEN
283: fnd_message.set_name('EAM', 'EAM_INVALID_PARAMETER');
284: fnd_message.set_token('NAME', 'p_external_source_name : ' || p_external_source_name);
285: fnd_msg_pub.add;
286: RAISE fnd_api.g_exc_error;
287: END IF;

Line 284: fnd_message.set_token('NAME', 'p_external_source_name : ' || p_external_source_name);

280: AND lookup_type = 'EAM_EXTERNAL_SOURCE_NAME');
281:
282: IF (l_count = 0) THEN
283: fnd_message.set_name('EAM', 'EAM_INVALID_PARAMETER');
284: fnd_message.set_token('NAME', 'p_external_source_name : ' || p_external_source_name);
285: fnd_msg_pub.add;
286: RAISE fnd_api.g_exc_error;
287: END IF;
288:

Line 291: fnd_message.set_name('EAM', 'EAM_INVALID_PARAMETER');

287: END IF;
288:
289: -- Validation of external_linear_id
290: IF (p_external_linear_id IS NULL) THEN
291: fnd_message.set_name('EAM', 'EAM_INVALID_PARAMETER');
292: fnd_message.set_token('NAME', 'p_external_linear_id : ' || p_external_linear_id);
293: fnd_msg_pub.add;
294: RAISE fnd_api.g_exc_error;
295: END IF;

Line 292: fnd_message.set_token('NAME', 'p_external_linear_id : ' || p_external_linear_id);

288:
289: -- Validation of external_linear_id
290: IF (p_external_linear_id IS NULL) THEN
291: fnd_message.set_name('EAM', 'EAM_INVALID_PARAMETER');
292: fnd_message.set_token('NAME', 'p_external_linear_id : ' || p_external_linear_id);
293: fnd_msg_pub.add;
294: RAISE fnd_api.g_exc_error;
295: END IF;
296:

Line 304: fnd_message.set_name('EAM', 'EAM_EXT_LINEAR_ID_EXISTS');

300: AND external_linear_type = p_external_linear_type
301: AND eam_linear_id <> p_eam_linear_id);
302:
303: IF (l_count > 0) THEN
304: fnd_message.set_name('EAM', 'EAM_EXT_LINEAR_ID_EXISTS');
305: fnd_msg_pub.add;
306: RAISE fnd_api.g_exc_error;
307: END IF;
308:

Line 398: fnd_message.set_name('EAM', 'EAM_INVALID_PARAMETER');

394: (SELECT 1 FROM mfg_lookups WHERE lookup_code = p_external_source_name
395: AND lookup_type = 'EAM_EXTERNAL_SOURCE_NAME');
396:
397: IF (l_count = 0) THEN
398: fnd_message.set_name('EAM', 'EAM_INVALID_PARAMETER');
399: fnd_message.set_token('NAME', 'p_external_source_name : ' || p_external_source_name);
400: fnd_msg_pub.add;
401: RAISE fnd_api.g_exc_error;
402: END IF;

Line 399: fnd_message.set_token('NAME', 'p_external_source_name : ' || p_external_source_name);

395: AND lookup_type = 'EAM_EXTERNAL_SOURCE_NAME');
396:
397: IF (l_count = 0) THEN
398: fnd_message.set_name('EAM', 'EAM_INVALID_PARAMETER');
399: fnd_message.set_token('NAME', 'p_external_source_name : ' || p_external_source_name);
400: fnd_msg_pub.add;
401: RAISE fnd_api.g_exc_error;
402: END IF;
403:

Line 413: --fnd_message.set_name('EAM', 'EAM_INVALID_EXT_LINEAR_ID');

409: AND external_linear_type = p_external_linear_type;
410: EXCEPTION
411: WHEN NO_DATA_FOUND THEN
412: x_eam_linear_id := -1;
413: --fnd_message.set_name('EAM', 'EAM_INVALID_EXT_LINEAR_ID');
414: --fnd_msg_pub.add;
415: --RAISE fnd_api.g_exc_error;
416: END;
417: