APPS.HZ_REGISTRY_VALIDATE_V2PUB dependencies on HZ_CITIZENSHIP

Line 8387: FROM hz_citizenship hc

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

Line 8418: FROM HZ_CITIZENSHIP

8414: l_party_id,
8415: l_status,
8416: l_created_by_module,
8417: l_application_id
8418: FROM HZ_CITIZENSHIP
8419: WHERE ROWID = p_rowid;
8420: END IF;
8421:
8422:

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

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

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

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

Line 8601: p_lookup_type => 'HZ_CITIZENSHIP_ACQUISITION',

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

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

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

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

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