APPS.HZ_REGISTRY_VALIDATE_V2PUB dependencies on HZ_ORG_CONTACTS

Line 6966: FROM HZ_ORG_CONTACTS

6962: l_job_title_code,
6963: l_department_code,
6964: l_created_by_module,
6965: l_application_id
6966: FROM HZ_ORG_CONTACTS
6967: WHERE ROWID = p_rowid;
6968: END IF;
6969:
6970: ---------------------------------

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

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

Line 7407: FROM HZ_ORG_CONTACTS

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

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

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

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

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

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

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

Line 7693: HZ_ORG_CONTACTS OC,

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

Line 7696: HZ_ORG_CONTACTS OC2

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