APPS.HZ_EMAIL_DOMAINS_V2PUB dependencies on HZ_PARTIES

Line 379: -- party_id has foreign key HZ_PARTIES.PARTY_ID

375: p_prefix =>l_debug_prefix,
376: p_msg_level=>fnd_log.level_statement);
377: END IF;
378:
379: -- party_id has foreign key HZ_PARTIES.PARTY_ID
380: IF p_party_id IS NOT NULL
381: AND
382: p_party_id <> fnd_api.g_miss_num
383: THEN

Line 387: FROM hz_parties p

383: THEN
384: BEGIN
385: SELECT 'Y'
386: INTO l_dummy
387: FROM hz_parties p
388: WHERE p.party_id = p_party_id;
389:
390: EXCEPTION
391: WHEN NO_DATA_FOUND THEN

Line 395: fnd_message.set_token('TABLE', 'hz_parties');

391: WHEN NO_DATA_FOUND THEN
392: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
393: fnd_message.set_token('FK', 'party_id');
394: fnd_message.set_token('COLUMN', 'party_id');
395: fnd_message.set_token('TABLE', 'hz_parties');
396: fnd_msg_pub.add;
397: x_return_status := fnd_api.g_ret_sts_error;
398: END;
399:

Line 402: hz_utility_v2pub.debug(p_message=>'party_id has foreign key hz_parties.party_id. ' ||

398: END;
399:
400:
401: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
402: hz_utility_v2pub.debug(p_message=>'party_id has foreign key hz_parties.party_id. ' ||
403: 'x_return_status = ' || x_return_status,
404: p_prefix =>l_debug_prefix,
405: p_msg_level=>fnd_log.level_statement);
406: END IF;

Line 453: from hz_parties

449: -- VJN introduced changes for the domain name project for ensuring
450: -- DQM sync happens, when ever an email domain is created, using this API.
451: BEGIN
452: select party_type into l_dummy
453: from hz_parties
454: where party_id = p_party_id;
455:
456: IF l_dummy = 'ORGANIZATION'
457: THEN

Line 469: fnd_message.set_token('TABLE', 'hz_parties');

465: WHEN NO_DATA_FOUND THEN
466: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
467: fnd_message.set_token('FK', 'party_id');
468: fnd_message.set_token('COLUMN', 'party_id');
469: fnd_message.set_token('TABLE', 'hz_parties');
470: fnd_msg_pub.add;
471: x_return_status := fnd_api.g_ret_sts_error;
472:
473:

Line 521: 'HZ_EMAIL_DOMAINS','HZ_PARTIES',

517:
518: check_params(p_entity_name, p_from_id, l_to_id, NULL,
519: p_from_id, p_par_entity_name,
520: 'HZ_EMAIL_DOMAINS_V2PUB.email_domains_merge',
521: 'HZ_EMAIL_DOMAINS','HZ_PARTIES',
522: 'EMAIL_DOMAIN_ID', 'PARTY_ID',x_return_status);
523:
524: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
525: l_dup_exists := HZ_EMAIL_DOMAINS_V2PUB.check_email_domain_dup(