APPS.HZ_REGISTRY_VALIDATE_V2PUB dependencies on HZ_CITIZENSHIP

Line 8390: FROM hz_citizenship hc

8386:
8387:
8388: CURSOR citizen_cur (p_citizenship_id IN NUMBER) IS
8389: SELECT 'Y'
8390: FROM hz_citizenship hc
8391: WHERE hc.citizenship_id = p_citizenship_id;
8392:
8393:
8394: BEGIN

Line 8421: FROM HZ_CITIZENSHIP

8417: l_party_id,
8418: l_status,
8419: l_created_by_module,
8420: l_application_id
8421: FROM HZ_CITIZENSHIP
8422: WHERE ROWID = p_rowid;
8423: END IF;
8424:
8425:

Line 8574: fnd_message.set_token('TABLE_NAME', 'HZ_CITIZENSHIP');

8570: EXCEPTION
8571: WHEN NO_DATA_FOUND THEN
8572: fnd_message.set_name('AR', 'HZ_API_PARTY_NOT_PERSON');
8573: -- fnd_message.set_token('FK', 'party_id');
8574: fnd_message.set_token('TABLE_NAME', 'HZ_CITIZENSHIP');
8575: fnd_message.set_token('PARTY_ID_COL', 'party_id');
8576: fnd_msg_pub.add;
8577: x_return_status := fnd_api.g_ret_sts_error;
8578: END;

Line 8600: -- birth_or_selected is lookup code in lookup type HZ_CITIZENSHIP_ACQUISITION

8596: ---------------------------------------
8597: -- validation for birth_or_selected
8598: ---------------------------------------
8599:
8600: -- birth_or_selected is lookup code in lookup type HZ_CITIZENSHIP_ACQUISITION
8601:
8602: validate_lookup (
8603: p_column => 'birth_or_selected',
8604: p_lookup_type => 'HZ_CITIZENSHIP_ACQUISITION',

Line 8604: p_lookup_type => 'HZ_CITIZENSHIP_ACQUISITION',

8600: -- birth_or_selected is lookup code in lookup type HZ_CITIZENSHIP_ACQUISITION
8601:
8602: validate_lookup (
8603: p_column => 'birth_or_selected',
8604: p_lookup_type => 'HZ_CITIZENSHIP_ACQUISITION',
8605: p_column_value => p_citizenship_rec.birth_or_selected,
8606: x_return_status => x_return_status);
8607:
8608:

Line 8611: 'birth_or_selected should be in lookup HZ_CITIZENSHIP_ACQUISITION. ' ||

8607:
8608:
8609: /*IF g_debug THEN
8610: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
8611: 'birth_or_selected should be in lookup HZ_CITIZENSHIP_ACQUISITION. ' ||
8612: 'x_return_status = ' || x_return_status, l_debug_prefix);
8613: END IF;
8614: */
8615: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 8617: p_message=>'birth_or_selected should be in lookup HZ_CITIZENSHIP_ACQUISITION. ' ||

8613: END IF;
8614: */
8615: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8616: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
8617: p_message=>'birth_or_selected should be in lookup HZ_CITIZENSHIP_ACQUISITION. ' ||
8618: 'x_return_status = ' || x_return_status,
8619: p_msg_level=>fnd_log.level_statement);
8620: END IF;
8621: