DBA Data[Home] [Help]

APPS.POS_PARTY_MERGE_PKG dependencies on FND_API

Line 202: x_return_status := fnd_api.g_ret_sts_unexp_error;

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;
205:
206: -- check parties for pending changes; if pending, fail merge

Line 211: x_return_status := fnd_api.g_ret_sts_error;

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;
214:
215: IF l_party_type = 'ORGANIZATION' THEN

Line 222: x_return_status := fnd_api.g_ret_sts_error;

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:
225: ELSE
226:

Line 227: x_return_status := fnd_api.g_ret_sts_success;

223: RETURN;
224:
225: ELSE
226:
227: x_return_status := fnd_api.g_ret_sts_success;
228: RETURN;
229:
230: END IF;
231:

Line 234: x_return_status := fnd_api.g_ret_sts_success;

230: END IF;
231:
232: ELSE
233: -- party type is not ORGANIZATION
234: x_return_status := fnd_api.g_ret_sts_success;
235: RETURN;
236:
237: END IF;
238:

Line 261: x_return_status := fnd_api.g_ret_sts_success;

257: FROM pos_supplier_mappings
258: WHERE party_id = p_old_party_id
259: );
260:
261: x_return_status := fnd_api.g_ret_sts_success;
262:
263: END update_supplier_mapping;
264:
265: -- public method called by party merge program

Line 336: x_return_status := fnd_api.g_ret_sts_unexp_error;

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:
339: END IF;
340:

Line 345: x_return_status := fnd_api.g_ret_sts_unexp_error;

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;
348:
349: -- validate p_from_fk_id and p_to_fk_id

Line 356: x_return_status := fnd_api.g_ret_sts_error;

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;
359:
360: OPEN l_party_cur(p_from_fk_id);

Line 367: x_return_status := fnd_api.g_ret_sts_error;

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;
370: CLOSE l_party_cur;
371:

Line 376: x_return_status := fnd_api.g_ret_sts_error;

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;
379:
380: OPEN l_party_cur(p_to_fk_id);

Line 387: x_return_status := fnd_api.g_ret_sts_error;

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;
390: CLOSE l_party_cur;
391:

Line 401: x_return_status := fnd_api.g_ret_sts_error;

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;
404: CLOSE l_party_site_cur;
405:

Line 413: x_return_status := fnd_api.g_ret_sts_error;

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;
416: CLOSE l_party_site_cur;
417:

Line 432: if (l_return_status = fnd_api.g_ret_sts_error) then

428:
429: check_party_for_veto(l_from_party_id, 'Y', l_return_status);
430:
431: -- If the check fails then veto the merge.
432: if (l_return_status = fnd_api.g_ret_sts_error) then
433: x_return_status := fnd_api.g_ret_sts_error;
434: RETURN;
435: END IF;
436:

Line 433: x_return_status := fnd_api.g_ret_sts_error;

429: check_party_for_veto(l_from_party_id, 'Y', l_return_status);
430:
431: -- If the check fails then veto the merge.
432: if (l_return_status = fnd_api.g_ret_sts_error) then
433: x_return_status := fnd_api.g_ret_sts_error;
434: RETURN;
435: END IF;
436:
437: update_supplier_mapping(p_from_fk_id, p_to_fk_id, l_return_status);

Line 443: IF l_return_status = fnd_api.g_ret_sts_success THEN

439: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
440: fnd_log.string(fnd_log.level_statement, l_module, 'return_status for from party ' || l_return_status);
441: END IF;
442:
443: IF l_return_status = fnd_api.g_ret_sts_success THEN
444: check_party_for_veto(l_to_party_id, 'N', l_return_status);
445: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
446: fnd_log.string(fnd_log.level_statement, l_module, 'return_status for from party ' || l_return_status);
447: END IF;

Line 457: x_return_status := fnd_api.g_ret_sts_unexp_error;

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;
460:
461: END pos_party_merge_pkg;