APPS.HZ_REGISTRY_VALIDATE_V2PUB dependencies on HZ_PHONE_COUNTRY_CODES

Line 1206: FROM hz_phone_country_codes hpcc

1202: WHERE ftl.upgrade_tz_id = p_timezone_id;
1203:
1204: CURSOR c_countrycode (p_phone_country_code IN VARCHAR2) IS
1205: SELECT 'Y'
1206: FROM hz_phone_country_codes hpcc
1207: WHERE hpcc.phone_country_code = p_phone_country_code
1208: AND ROWNUM = 1;
1209:
1210: BEGIN

Line 2494: -- phone_country_code is foreign key of hz_phone_country_codes

2490: --------------------------------------
2491: -- validate phone_country_code
2492: --------------------------------------
2493:
2494: -- phone_country_code is foreign key of hz_phone_country_codes
2495: -- Bug 2007066: during update, only validate phone_country_code if it
2496: -- has been changed.
2497: IF p_phone_rec.phone_country_code IS NOT NULL AND
2498: p_phone_rec.phone_country_code <> fnd_api.g_miss_char AND

Line 2518: 'PHONE : phone_country_code is foreign key of hz_phone_country_codes. ' ||

2514: CLOSE c_countrycode;
2515:
2516: /*IF g_debug THEN
2517: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
2518: 'PHONE : phone_country_code is foreign key of hz_phone_country_codes. ' ||
2519: 'x_return_status = ' || x_return_status, l_debug_prefix);
2520: END IF;
2521: */
2522: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 2524: p_message=>'PHONE : phone_country_code is foreign key of hz_phone_country_codes. ' ||

2520: END IF;
2521: */
2522: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2523: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
2524: p_message=>'PHONE : phone_country_code is foreign key of hz_phone_country_codes. ' ||
2525: 'x_return_status = ' || x_return_status,
2526: p_msg_level=>fnd_log.level_statement);
2527: END IF;
2528: