APPS.HZ_REGISTRY_VALIDATE_V2PUB dependencies on HZ_ORG_CONTACTS

Line 6969: FROM HZ_ORG_CONTACTS

6965: l_job_title_code,
6966: l_department_code,
6967: l_created_by_module,
6968: l_application_id
6969: FROM HZ_ORG_CONTACTS
6970: WHERE ROWID = p_rowid;
6971: END IF;
6972:
6973: ---------------------------------

Line 7399: -- org_contact_id is foreign key of hz_org_contacts.org_contact_id.

7395: END IF;
7396:
7397: END IF;
7398:
7399: -- org_contact_id is foreign key of hz_org_contacts.org_contact_id.
7400: -- do not need to check during update because org_contact_id is
7401: -- non-updateable.
7402: IF p_create_update_flag = 'C'
7403: AND

Line 7410: FROM HZ_ORG_CONTACTS

7406: THEN
7407: BEGIN
7408: SELECT 'Y'
7409: INTO l_dummy
7410: FROM HZ_ORG_CONTACTS
7411: WHERE ORG_CONTACT_ID = p_org_contact_role_rec.org_contact_id;
7412: EXCEPTION
7413: WHEN NO_DATA_FOUND THEN
7414: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

Line 7417: fnd_message.set_token('TABLE', 'hz_org_contacts');

7413: WHEN NO_DATA_FOUND THEN
7414: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
7415: fnd_message.set_token('FK', 'org_contact_id');
7416: fnd_message.set_token('COLUMN', 'org_contact_id');
7417: fnd_message.set_token('TABLE', 'hz_org_contacts');
7418: fnd_msg_pub.add;
7419: x_return_status := fnd_api.g_ret_sts_error;
7420: END;
7421:

Line 7424: 'org_contact_id is foreign key of hz_org_contacts.org_contact_id. ' ||

7420: END;
7421:
7422: /*IF g_debug THEN
7423: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
7424: 'org_contact_id is foreign key of hz_org_contacts.org_contact_id. ' ||
7425: 'x_return_status = ' || x_return_status, l_debug_prefix);
7426: END IF;
7427: */
7428: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 7430: p_message=>'org_contact_id is foreign key of hz_org_contacts.org_contact_id. ' ||

7426: END IF;
7427: */
7428: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7429: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
7430: p_message=>'org_contact_id is foreign key of hz_org_contacts.org_contact_id. ' ||
7431: 'x_return_status = ' || x_return_status,
7432: p_msg_level=>fnd_log.level_statement);
7433: END IF;
7434:

Line 7696: HZ_ORG_CONTACTS OC,

7692: BEGIN
7693: SELECT 'Y'
7694: INTO l_dummy
7695: FROM HZ_RELATIONSHIPS PR,
7696: HZ_ORG_CONTACTS OC,
7697: HZ_ORG_CONTACT_ROLES OCR,
7698: HZ_RELATIONSHIPS PR2,
7699: HZ_ORG_CONTACTS OC2
7700: WHERE OCR.PRIMARY_CONTACT_PER_ROLE_TYPE = 'Y'

Line 7699: HZ_ORG_CONTACTS OC2

7695: FROM HZ_RELATIONSHIPS PR,
7696: HZ_ORG_CONTACTS OC,
7697: HZ_ORG_CONTACT_ROLES OCR,
7698: HZ_RELATIONSHIPS PR2,
7699: HZ_ORG_CONTACTS OC2
7700: WHERE OCR.PRIMARY_CONTACT_PER_ROLE_TYPE = 'Y'
7701: AND OCR.ROLE_TYPE = p_org_contact_role_rec.role_type
7702: AND OCR.ORG_CONTACT_ID = OC.ORG_CONTACT_ID
7703: AND OC.PARTY_RELATIONSHIP_ID = PR.RELATIONSHIP_ID