DBA Data[Home] [Help]

APPS.POS_PARTY_MERGE_PKG dependencies on FND_MESSAGE

Line 199: fnd_message.set_name('POS','POS_PTYM_INVALID_PARTY_ID');

195: BEGIN
196: get_party_info(p_party_id, l_found, l_party_type, l_party_name);
197:
198: IF l_found = FALSE THEN
199: fnd_message.set_name('POS','POS_PTYM_INVALID_PARTY_ID');
200: fnd_message.set_token('PARTY_ID', p_party_id);
201: fnd_msg_pub.ADD;
202: x_return_status := fnd_api.g_ret_sts_unexp_error;
203: RETURN;

Line 200: fnd_message.set_token('PARTY_ID', p_party_id);

196: get_party_info(p_party_id, l_found, l_party_type, l_party_name);
197:
198: IF l_found = FALSE THEN
199: fnd_message.set_name('POS','POS_PTYM_INVALID_PARTY_ID');
200: fnd_message.set_token('PARTY_ID', p_party_id);
201: fnd_msg_pub.ADD;
202: x_return_status := fnd_api.g_ret_sts_unexp_error;
203: RETURN;
204: END IF;

Line 208: fnd_message.set_name('POS', 'POS_PENDING_CHANGE');

204: END IF;
205:
206: -- check parties for pending changes; if pending, fail merge
207: IF (p_is_from_party = 'Y' AND has_pending_change(p_party_id)) THEN
208: fnd_message.set_name('POS', 'POS_PENDING_CHANGE');
209: fnd_message.set_token('PARTY_NAME', l_party_name);
210: fnd_msg_pub.ADD;
211: x_return_status := fnd_api.g_ret_sts_error;
212: RETURN;

Line 209: fnd_message.set_token('PARTY_NAME', l_party_name);

205:
206: -- check parties for pending changes; if pending, fail merge
207: IF (p_is_from_party = 'Y' AND has_pending_change(p_party_id)) THEN
208: fnd_message.set_name('POS', 'POS_PENDING_CHANGE');
209: fnd_message.set_token('PARTY_NAME', l_party_name);
210: fnd_msg_pub.ADD;
211: x_return_status := fnd_api.g_ret_sts_error;
212: RETURN;
213: END IF;

Line 219: fnd_message.set_name('POS','POS_PTYM_IS_ENTERPRISE');

215: IF l_party_type = 'ORGANIZATION' THEN
216:
217: IF is_enterprise_party(p_party_id) THEN
218:
219: fnd_message.set_name('POS','POS_PTYM_IS_ENTERPRISE');
220: fnd_message.set_token('PARTY_NAME', l_party_name);
221: fnd_msg_pub.ADD;
222: x_return_status := fnd_api.g_ret_sts_error;
223: RETURN;

Line 220: fnd_message.set_token('PARTY_NAME', l_party_name);

216:
217: IF is_enterprise_party(p_party_id) THEN
218:
219: fnd_message.set_name('POS','POS_PTYM_IS_ENTERPRISE');
220: fnd_message.set_token('PARTY_NAME', l_party_name);
221: fnd_msg_pub.ADD;
222: x_return_status := fnd_api.g_ret_sts_error;
223: RETURN;
224:

Line 333: fnd_message.set_name('POS','POS_PTYM_NULL_PARAM');

329: ELSE
330: l_invalid_param := 'p_to_fk_id';
331: END IF;
332:
333: fnd_message.set_name('POS','POS_PTYM_NULL_PARAM');
334: fnd_message.set_token('INPUT_PARAMETER',l_invalid_param);
335: fnd_msg_pub.ADD;
336: x_return_status := fnd_api.g_ret_sts_unexp_error;
337: RETURN;

Line 334: fnd_message.set_token('INPUT_PARAMETER',l_invalid_param);

330: l_invalid_param := 'p_to_fk_id';
331: END IF;
332:
333: fnd_message.set_name('POS','POS_PTYM_NULL_PARAM');
334: fnd_message.set_token('INPUT_PARAMETER',l_invalid_param);
335: fnd_msg_pub.ADD;
336: x_return_status := fnd_api.g_ret_sts_unexp_error;
337: RETURN;
338:

Line 342: fnd_message.set_name('POS','POS_PTYM_BAD_PARENT_ENTITY');

338:
339: END IF;
340:
341: IF p_parent_entity_name NOT IN ('HZ_PARTIES', 'HZ_PARTY_SITES') THEN
342: fnd_message.set_name('POS','POS_PTYM_BAD_PARENT_ENTITY');
343: fnd_message.set_token('PARENT_ENTITY_NAME', p_parent_entity_name);
344: fnd_msg_pub.ADD;
345: x_return_status := fnd_api.g_ret_sts_unexp_error;
346: RETURN;

Line 343: fnd_message.set_token('PARENT_ENTITY_NAME', p_parent_entity_name);

339: END IF;
340:
341: IF p_parent_entity_name NOT IN ('HZ_PARTIES', 'HZ_PARTY_SITES') THEN
342: fnd_message.set_name('POS','POS_PTYM_BAD_PARENT_ENTITY');
343: fnd_message.set_token('PARENT_ENTITY_NAME', p_parent_entity_name);
344: fnd_msg_pub.ADD;
345: x_return_status := fnd_api.g_ret_sts_unexp_error;
346: RETURN;
347: END IF;

Line 353: fnd_message.set_name('POS','POS_PTYM_BAD_PARTY_ID');

349: -- validate p_from_fk_id and p_to_fk_id
350: IF p_parent_entity_name = 'HZ_PARTIES' THEN
351:
352: IF p_from_fk_id IS NULL THEN
353: fnd_message.set_name('POS','POS_PTYM_BAD_PARTY_ID');
354: fnd_message.set_token('PARTY_ID', p_from_fk_id);
355: fnd_msg_pub.ADD;
356: x_return_status := fnd_api.g_ret_sts_error;
357: RETURN;

Line 354: fnd_message.set_token('PARTY_ID', p_from_fk_id);

350: IF p_parent_entity_name = 'HZ_PARTIES' THEN
351:
352: IF p_from_fk_id IS NULL THEN
353: fnd_message.set_name('POS','POS_PTYM_BAD_PARTY_ID');
354: fnd_message.set_token('PARTY_ID', p_from_fk_id);
355: fnd_msg_pub.ADD;
356: x_return_status := fnd_api.g_ret_sts_error;
357: RETURN;
358: END IF;

Line 364: fnd_message.set_name('POS','POS_PTYM_BAD_PARTY_ID');

360: OPEN l_party_cur(p_from_fk_id);
361: FETCH l_party_cur INTO l_from_party_id;
362: IF l_party_cur%notfound THEN
363: CLOSE l_party_cur;
364: fnd_message.set_name('POS','POS_PTYM_BAD_PARTY_ID');
365: fnd_message.set_token('PARTY_SITE_ID', p_to_fk_id);
366: fnd_msg_pub.ADD;
367: x_return_status := fnd_api.g_ret_sts_error;
368: RETURN;

Line 365: fnd_message.set_token('PARTY_SITE_ID', p_to_fk_id);

361: FETCH l_party_cur INTO l_from_party_id;
362: IF l_party_cur%notfound THEN
363: CLOSE l_party_cur;
364: fnd_message.set_name('POS','POS_PTYM_BAD_PARTY_ID');
365: fnd_message.set_token('PARTY_SITE_ID', p_to_fk_id);
366: fnd_msg_pub.ADD;
367: x_return_status := fnd_api.g_ret_sts_error;
368: RETURN;
369: END IF;

Line 373: fnd_message.set_name('POS','POS_PTYM_BAD_PARTY_ID');

369: END IF;
370: CLOSE l_party_cur;
371:
372: IF p_to_fk_id IS NULL THEN
373: fnd_message.set_name('POS','POS_PTYM_BAD_PARTY_ID');
374: fnd_message.set_token('PARTY_ID', p_to_fk_id);
375: fnd_msg_pub.ADD;
376: x_return_status := fnd_api.g_ret_sts_error;
377: RETURN;

Line 374: fnd_message.set_token('PARTY_ID', p_to_fk_id);

370: CLOSE l_party_cur;
371:
372: IF p_to_fk_id IS NULL THEN
373: fnd_message.set_name('POS','POS_PTYM_BAD_PARTY_ID');
374: fnd_message.set_token('PARTY_ID', p_to_fk_id);
375: fnd_msg_pub.ADD;
376: x_return_status := fnd_api.g_ret_sts_error;
377: RETURN;
378: END IF;

Line 384: fnd_message.set_name('POS','POS_PTYM_BAD_PARTY_ID');

380: OPEN l_party_cur(p_to_fk_id);
381: FETCH l_party_cur INTO l_to_party_id;
382: IF l_party_cur%notfound THEN
383: CLOSE l_party_cur;
384: fnd_message.set_name('POS','POS_PTYM_BAD_PARTY_ID');
385: fnd_message.set_token('PARTY_ID', p_to_fk_id);
386: fnd_msg_pub.ADD;
387: x_return_status := fnd_api.g_ret_sts_error;
388: RETURN;

Line 385: fnd_message.set_token('PARTY_ID', p_to_fk_id);

381: FETCH l_party_cur INTO l_to_party_id;
382: IF l_party_cur%notfound THEN
383: CLOSE l_party_cur;
384: fnd_message.set_name('POS','POS_PTYM_BAD_PARTY_ID');
385: fnd_message.set_token('PARTY_ID', p_to_fk_id);
386: fnd_msg_pub.ADD;
387: x_return_status := fnd_api.g_ret_sts_error;
388: RETURN;
389: END IF;

Line 398: fnd_message.set_name('POS','POS_PTYM_BAD_PARTY_SITE_ID');

394: OPEN l_party_site_cur(p_from_fk_id);
395: FETCH l_party_site_cur INTO l_from_party_id;
396: IF l_party_site_cur%notfound THEN
397: CLOSE l_party_site_cur;
398: fnd_message.set_name('POS','POS_PTYM_BAD_PARTY_SITE_ID');
399: fnd_message.set_token('PARTY_SITE_ID', p_from_fk_id);
400: fnd_msg_pub.ADD;
401: x_return_status := fnd_api.g_ret_sts_error;
402: RETURN;

Line 399: fnd_message.set_token('PARTY_SITE_ID', p_from_fk_id);

395: FETCH l_party_site_cur INTO l_from_party_id;
396: IF l_party_site_cur%notfound THEN
397: CLOSE l_party_site_cur;
398: fnd_message.set_name('POS','POS_PTYM_BAD_PARTY_SITE_ID');
399: fnd_message.set_token('PARTY_SITE_ID', p_from_fk_id);
400: fnd_msg_pub.ADD;
401: x_return_status := fnd_api.g_ret_sts_error;
402: RETURN;
403: END IF;

Line 410: fnd_message.set_name('POS','POS_PTYM_BAD_PARTY_SITE_ID');

406: OPEN l_party_site_cur(p_to_fk_id);
407: FETCH l_party_site_cur INTO l_to_party_id;
408: IF l_party_site_cur%notfound THEN
409: CLOSE l_party_site_cur;
410: fnd_message.set_name('POS','POS_PTYM_BAD_PARTY_SITE_ID');
411: fnd_message.set_token('PARTY_SITE_ID', p_to_fk_id);
412: fnd_msg_pub.ADD;
413: x_return_status := fnd_api.g_ret_sts_error;
414: RETURN;

Line 411: fnd_message.set_token('PARTY_SITE_ID', p_to_fk_id);

407: FETCH l_party_site_cur INTO l_to_party_id;
408: IF l_party_site_cur%notfound THEN
409: CLOSE l_party_site_cur;
410: fnd_message.set_name('POS','POS_PTYM_BAD_PARTY_SITE_ID');
411: fnd_message.set_token('PARTY_SITE_ID', p_to_fk_id);
412: fnd_msg_pub.ADD;
413: x_return_status := fnd_api.g_ret_sts_error;
414: RETURN;
415: END IF;

Line 454: fnd_message.set_name('POS','POS_PTYM_UNEXP_ERR');

450: x_return_status := l_return_status;
451:
452: EXCEPTION
453: WHEN OTHERS THEN
454: fnd_message.set_name('POS','POS_PTYM_UNEXP_ERR');
455: fnd_message.set_token('ERROR',Sqlerrm);
456: fnd_msg_pub.ADD;
457: x_return_status := fnd_api.g_ret_sts_unexp_error;
458:

Line 455: fnd_message.set_token('ERROR',Sqlerrm);

451:
452: EXCEPTION
453: WHEN OTHERS THEN
454: fnd_message.set_name('POS','POS_PTYM_UNEXP_ERR');
455: fnd_message.set_token('ERROR',Sqlerrm);
456: fnd_msg_pub.ADD;
457: x_return_status := fnd_api.g_ret_sts_unexp_error;
458:
459: END party_merge_routine;