1730: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
1731: END IF;
1732:
1733: -- Debug info.
1734: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1735: hz_utility_v2pub.debug(p_message=>'do_create_contact_point(+)',
1736: p_prefix=>l_debug_prefix,
1737: p_msg_level=>fnd_log.level_procedure);
1738: END IF;
1733: -- Debug info.
1734: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1735: hz_utility_v2pub.debug(p_message=>'do_create_contact_point(+)',
1736: p_prefix=>l_debug_prefix,
1737: p_msg_level=>fnd_log.level_procedure);
1738: END IF;
1739:
1740: -- Base on p_validate_bo_flag, check completeness of business object
1741: IF(p_validate_bo_flag = FND_API.G_TRUE) THEN
1993: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1994: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1995:
1996: -- Debug info.
1997: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1998: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1999: p_msg_data=>x_msg_data,
2000: p_msg_type=>'WARNING',
2001: p_msg_level=>fnd_log.level_exception);
1997: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1998: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1999: p_msg_data=>x_msg_data,
2000: p_msg_type=>'WARNING',
2001: p_msg_level=>fnd_log.level_exception);
2002: END IF;
2003: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2004: hz_utility_v2pub.debug(p_message=>'do_create_contact_point(-)',
2005: p_prefix=>l_debug_prefix,
1999: p_msg_data=>x_msg_data,
2000: p_msg_type=>'WARNING',
2001: p_msg_level=>fnd_log.level_exception);
2002: END IF;
2003: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2004: hz_utility_v2pub.debug(p_message=>'do_create_contact_point(-)',
2005: p_prefix=>l_debug_prefix,
2006: p_msg_level=>fnd_log.level_procedure);
2007: END IF;
2002: END IF;
2003: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2004: hz_utility_v2pub.debug(p_message=>'do_create_contact_point(-)',
2005: p_prefix=>l_debug_prefix,
2006: p_msg_level=>fnd_log.level_procedure);
2007: END IF;
2008:
2009: EXCEPTION
2010: WHEN fnd_api.g_exc_error THEN
2024: p_count => x_msg_count,
2025: p_data => x_msg_data);
2026:
2027: -- Debug info.
2028: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2029: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2030: p_msg_data=>x_msg_data,
2031: p_msg_type=>'ERROR',
2032: p_msg_level=>fnd_log.level_error);
2028: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2029: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2030: p_msg_data=>x_msg_data,
2031: p_msg_type=>'ERROR',
2032: p_msg_level=>fnd_log.level_error);
2033: END IF;
2034: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2035: hz_utility_v2pub.debug(p_message=>'do_create_contact_point (-)',
2036: p_prefix=>l_debug_prefix,
2030: p_msg_data=>x_msg_data,
2031: p_msg_type=>'ERROR',
2032: p_msg_level=>fnd_log.level_error);
2033: END IF;
2034: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2035: hz_utility_v2pub.debug(p_message=>'do_create_contact_point (-)',
2036: p_prefix=>l_debug_prefix,
2037: p_msg_level=>fnd_log.level_procedure);
2038: END IF;
2033: END IF;
2034: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2035: hz_utility_v2pub.debug(p_message=>'do_create_contact_point (-)',
2036: p_prefix=>l_debug_prefix,
2037: p_msg_level=>fnd_log.level_procedure);
2038: END IF;
2039:
2040: WHEN fnd_api.g_exc_unexpected_error THEN
2041: ROLLBACK TO do_create_contact_point_pub;
2054: p_count => x_msg_count,
2055: p_data => x_msg_data);
2056:
2057: -- Debug info.
2058: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2059: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2060: p_msg_data=>x_msg_data,
2061: p_msg_type=>'UNEXPECTED ERROR',
2062: p_msg_level=>fnd_log.level_error);
2058: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2059: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2060: p_msg_data=>x_msg_data,
2061: p_msg_type=>'UNEXPECTED ERROR',
2062: p_msg_level=>fnd_log.level_error);
2063: END IF;
2064: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2065: hz_utility_v2pub.debug(p_message=>'do_create_contact_point (-)',
2066: p_prefix=>l_debug_prefix,
2060: p_msg_data=>x_msg_data,
2061: p_msg_type=>'UNEXPECTED ERROR',
2062: p_msg_level=>fnd_log.level_error);
2063: END IF;
2064: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2065: hz_utility_v2pub.debug(p_message=>'do_create_contact_point (-)',
2066: p_prefix=>l_debug_prefix,
2067: p_msg_level=>fnd_log.level_procedure);
2068: END IF;
2063: END IF;
2064: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2065: hz_utility_v2pub.debug(p_message=>'do_create_contact_point (-)',
2066: p_prefix=>l_debug_prefix,
2067: p_msg_level=>fnd_log.level_procedure);
2068: END IF;
2069:
2070: WHEN OTHERS THEN
2071: ROLLBACK TO do_create_contact_point_pub;
2088: p_count => x_msg_count,
2089: p_data => x_msg_data);
2090:
2091: -- Debug info.
2092: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2093: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2094: p_msg_data=>x_msg_data,
2095: p_msg_type=>'SQL ERROR',
2096: p_msg_level=>fnd_log.level_error);
2092: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2093: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2094: p_msg_data=>x_msg_data,
2095: p_msg_type=>'SQL ERROR',
2096: p_msg_level=>fnd_log.level_error);
2097: END IF;
2098: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2099: hz_utility_v2pub.debug(p_message=>'do_create_contact_point (-)',
2100: p_prefix=>l_debug_prefix,
2094: p_msg_data=>x_msg_data,
2095: p_msg_type=>'SQL ERROR',
2096: p_msg_level=>fnd_log.level_error);
2097: END IF;
2098: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2099: hz_utility_v2pub.debug(p_message=>'do_create_contact_point (-)',
2100: p_prefix=>l_debug_prefix,
2101: p_msg_level=>fnd_log.level_procedure);
2102: END IF;
2097: END IF;
2098: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2099: hz_utility_v2pub.debug(p_message=>'do_create_contact_point (-)',
2100: p_prefix=>l_debug_prefix,
2101: p_msg_level=>fnd_log.level_procedure);
2102: END IF;
2103: END do_create_contact_point;
2104:
2105: -- PROCEDURE update_phone_bo
2811: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
2812: END IF;
2813:
2814: -- Debug info.
2815: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2816: hz_utility_v2pub.debug(p_message=>'do_update_contact_point (+)',
2817: p_prefix=>l_debug_prefix,
2818: p_msg_level=>fnd_log.level_procedure);
2819: END IF;
2814: -- Debug info.
2815: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2816: hz_utility_v2pub.debug(p_message=>'do_update_contact_point (+)',
2817: p_prefix=>l_debug_prefix,
2818: p_msg_level=>fnd_log.level_procedure);
2819: END IF;
2820:
2821: -- get contact point id and os+osr
2822: x_cp_id := p_cp_id;
3048: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
3049: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
3050:
3051: -- Debug info.
3052: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3053: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3054: p_msg_data=>x_msg_data,
3055: p_msg_type=>'WARNING',
3056: p_msg_level=>fnd_log.level_exception);
3052: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3053: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3054: p_msg_data=>x_msg_data,
3055: p_msg_type=>'WARNING',
3056: p_msg_level=>fnd_log.level_exception);
3057: END IF;
3058: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3059: hz_utility_v2pub.debug(p_message=>'update_logical_cp(-)',
3060: p_prefix=>l_debug_prefix,
3054: p_msg_data=>x_msg_data,
3055: p_msg_type=>'WARNING',
3056: p_msg_level=>fnd_log.level_exception);
3057: END IF;
3058: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3059: hz_utility_v2pub.debug(p_message=>'update_logical_cp(-)',
3060: p_prefix=>l_debug_prefix,
3061: p_msg_level=>fnd_log.level_procedure);
3062: END IF;
3057: END IF;
3058: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3059: hz_utility_v2pub.debug(p_message=>'update_logical_cp(-)',
3060: p_prefix=>l_debug_prefix,
3061: p_msg_level=>fnd_log.level_procedure);
3062: END IF;
3063:
3064: EXCEPTION
3065: WHEN fnd_api.g_exc_error THEN
3079: p_count => x_msg_count,
3080: p_data => x_msg_data);
3081:
3082: -- Debug info.
3083: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3084: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3085: p_msg_data=>x_msg_data,
3086: p_msg_type=>'ERROR',
3087: p_msg_level=>fnd_log.level_error);
3083: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3084: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3085: p_msg_data=>x_msg_data,
3086: p_msg_type=>'ERROR',
3087: p_msg_level=>fnd_log.level_error);
3088: END IF;
3089: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3090: hz_utility_v2pub.debug(p_message=>'do_update_contact_point (-)',
3091: p_prefix=>l_debug_prefix,
3085: p_msg_data=>x_msg_data,
3086: p_msg_type=>'ERROR',
3087: p_msg_level=>fnd_log.level_error);
3088: END IF;
3089: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3090: hz_utility_v2pub.debug(p_message=>'do_update_contact_point (-)',
3091: p_prefix=>l_debug_prefix,
3092: p_msg_level=>fnd_log.level_procedure);
3093: END IF;
3088: END IF;
3089: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3090: hz_utility_v2pub.debug(p_message=>'do_update_contact_point (-)',
3091: p_prefix=>l_debug_prefix,
3092: p_msg_level=>fnd_log.level_procedure);
3093: END IF;
3094:
3095: WHEN fnd_api.g_exc_unexpected_error THEN
3096: ROLLBACK TO do_update_contact_point_pub;
3109: p_count => x_msg_count,
3110: p_data => x_msg_data);
3111:
3112: -- Debug info.
3113: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3114: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3115: p_msg_data=>x_msg_data,
3116: p_msg_type=>'UNEXPECTED ERROR',
3117: p_msg_level=>fnd_log.level_error);
3113: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3114: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3115: p_msg_data=>x_msg_data,
3116: p_msg_type=>'UNEXPECTED ERROR',
3117: p_msg_level=>fnd_log.level_error);
3118: END IF;
3119: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3120: hz_utility_v2pub.debug(p_message=>'do_update_contact_point (-)',
3121: p_prefix=>l_debug_prefix,
3115: p_msg_data=>x_msg_data,
3116: p_msg_type=>'UNEXPECTED ERROR',
3117: p_msg_level=>fnd_log.level_error);
3118: END IF;
3119: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3120: hz_utility_v2pub.debug(p_message=>'do_update_contact_point (-)',
3121: p_prefix=>l_debug_prefix,
3122: p_msg_level=>fnd_log.level_procedure);
3123: END IF;
3118: END IF;
3119: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3120: hz_utility_v2pub.debug(p_message=>'do_update_contact_point (-)',
3121: p_prefix=>l_debug_prefix,
3122: p_msg_level=>fnd_log.level_procedure);
3123: END IF;
3124:
3125: WHEN OTHERS THEN
3126: ROLLBACK TO do_update_contact_point_pub;
3143: p_count => x_msg_count,
3144: p_data => x_msg_data);
3145:
3146: -- Debug info.
3147: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3148: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3149: p_msg_data=>x_msg_data,
3150: p_msg_type=>'SQL ERROR',
3151: p_msg_level=>fnd_log.level_error);
3147: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3148: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3149: p_msg_data=>x_msg_data,
3150: p_msg_type=>'SQL ERROR',
3151: p_msg_level=>fnd_log.level_error);
3152: END IF;
3153: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3154: hz_utility_v2pub.debug(p_message=>'do_update_contact_point (-)',
3155: p_prefix=>l_debug_prefix,
3149: p_msg_data=>x_msg_data,
3150: p_msg_type=>'SQL ERROR',
3151: p_msg_level=>fnd_log.level_error);
3152: END IF;
3153: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3154: hz_utility_v2pub.debug(p_message=>'do_update_contact_point (-)',
3155: p_prefix=>l_debug_prefix,
3156: p_msg_level=>fnd_log.level_procedure);
3157: END IF;
3152: END IF;
3153: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3154: hz_utility_v2pub.debug(p_message=>'do_update_contact_point (-)',
3155: p_prefix=>l_debug_prefix,
3156: p_msg_level=>fnd_log.level_procedure);
3157: END IF;
3158: END do_update_contact_point;
3159:
3160: -- PROCEDURE save_phone_bo
3995: FND_MSG_PUB.initialize;
3996: END IF;
3997:
3998: -- Debug info.
3999: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4000: hz_utility_v2pub.debug(p_message=>'do_save_contact_point(+)',
4001: p_prefix=>l_debug_prefix,
4002: p_msg_level=>fnd_log.level_procedure);
4003: END IF;
3998: -- Debug info.
3999: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4000: hz_utility_v2pub.debug(p_message=>'do_save_contact_point(+)',
4001: p_prefix=>l_debug_prefix,
4002: p_msg_level=>fnd_log.level_procedure);
4003: END IF;
4004:
4005: -- initialize Global variable
4006: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
4431: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
4432: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
4433:
4434: -- Debug info.
4435: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
4436: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4437: p_msg_data=>x_msg_data,
4438: p_msg_type=>'WARNING',
4439: p_msg_level=>fnd_log.level_exception);
4435: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
4436: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4437: p_msg_data=>x_msg_data,
4438: p_msg_type=>'WARNING',
4439: p_msg_level=>fnd_log.level_exception);
4440: END IF;
4441: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4442: hz_utility_v2pub.debug(p_message=>'do_save_contact_point(-)',
4443: p_prefix=>l_debug_prefix,
4437: p_msg_data=>x_msg_data,
4438: p_msg_type=>'WARNING',
4439: p_msg_level=>fnd_log.level_exception);
4440: END IF;
4441: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4442: hz_utility_v2pub.debug(p_message=>'do_save_contact_point(-)',
4443: p_prefix=>l_debug_prefix,
4444: p_msg_level=>fnd_log.level_procedure);
4445: END IF;
4440: END IF;
4441: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4442: hz_utility_v2pub.debug(p_message=>'do_save_contact_point(-)',
4443: p_prefix=>l_debug_prefix,
4444: p_msg_level=>fnd_log.level_procedure);
4445: END IF;
4446:
4447: EXCEPTION
4448: WHEN fnd_api.g_exc_error THEN
4456: p_count => x_msg_count,
4457: p_data => x_msg_data);
4458:
4459: -- Debug info.
4460: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4461: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4462: p_msg_data=>x_msg_data,
4463: p_msg_type=>'ERROR',
4464: p_msg_level=>fnd_log.level_error);
4460: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4461: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4462: p_msg_data=>x_msg_data,
4463: p_msg_type=>'ERROR',
4464: p_msg_level=>fnd_log.level_error);
4465: END IF;
4466: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4467: hz_utility_v2pub.debug(p_message=>'do_save_contact_point(-)',
4468: p_prefix=>l_debug_prefix,
4462: p_msg_data=>x_msg_data,
4463: p_msg_type=>'ERROR',
4464: p_msg_level=>fnd_log.level_error);
4465: END IF;
4466: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4467: hz_utility_v2pub.debug(p_message=>'do_save_contact_point(-)',
4468: p_prefix=>l_debug_prefix,
4469: p_msg_level=>fnd_log.level_procedure);
4470: END IF;
4465: END IF;
4466: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4467: hz_utility_v2pub.debug(p_message=>'do_save_contact_point(-)',
4468: p_prefix=>l_debug_prefix,
4469: p_msg_level=>fnd_log.level_procedure);
4470: END IF;
4471:
4472: WHEN fnd_api.g_exc_unexpected_error THEN
4473: -- reset Global variable
4480: p_count => x_msg_count,
4481: p_data => x_msg_data);
4482:
4483: -- Debug info.
4484: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4485: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4486: p_msg_data=>x_msg_data,
4487: p_msg_type=>'UNEXPECTED ERROR',
4488: p_msg_level=>fnd_log.level_error);
4484: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4485: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4486: p_msg_data=>x_msg_data,
4487: p_msg_type=>'UNEXPECTED ERROR',
4488: p_msg_level=>fnd_log.level_error);
4489: END IF;
4490: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4491: hz_utility_v2pub.debug(p_message=>'do_save_contact_point(-)',
4492: p_prefix=>l_debug_prefix,
4486: p_msg_data=>x_msg_data,
4487: p_msg_type=>'UNEXPECTED ERROR',
4488: p_msg_level=>fnd_log.level_error);
4489: END IF;
4490: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4491: hz_utility_v2pub.debug(p_message=>'do_save_contact_point(-)',
4492: p_prefix=>l_debug_prefix,
4493: p_msg_level=>fnd_log.level_procedure);
4494: END IF;
4489: END IF;
4490: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4491: hz_utility_v2pub.debug(p_message=>'do_save_contact_point(-)',
4492: p_prefix=>l_debug_prefix,
4493: p_msg_level=>fnd_log.level_procedure);
4494: END IF;
4495: WHEN OTHERS THEN
4496: -- reset Global variable
4497: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
4507: p_count => x_msg_count,
4508: p_data => x_msg_data);
4509:
4510: -- Debug info.
4511: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4512: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4513: p_msg_data=>x_msg_data,
4514: p_msg_type=>'SQL ERROR',
4515: p_msg_level=>fnd_log.level_error);
4511: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4512: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4513: p_msg_data=>x_msg_data,
4514: p_msg_type=>'SQL ERROR',
4515: p_msg_level=>fnd_log.level_error);
4516: END IF;
4517: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4518: hz_utility_v2pub.debug(p_message=>'do_save_contact_point(-)',
4519: p_prefix=>l_debug_prefix,
4513: p_msg_data=>x_msg_data,
4514: p_msg_type=>'SQL ERROR',
4515: p_msg_level=>fnd_log.level_error);
4516: END IF;
4517: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4518: hz_utility_v2pub.debug(p_message=>'do_save_contact_point(-)',
4519: p_prefix=>l_debug_prefix,
4520: p_msg_level=>fnd_log.level_procedure);
4521: END IF;
4516: END IF;
4517: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4518: hz_utility_v2pub.debug(p_message=>'do_save_contact_point(-)',
4519: p_prefix=>l_debug_prefix,
4520: p_msg_level=>fnd_log.level_procedure);
4521: END IF;
4522: END do_save_contact_point;
4523:
4524: /*
4627: END IF;
4628:
4629:
4630: -- Debug info.
4631: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4632: hz_utility_v2pub.debug(p_message=>'hz_phone_bo_pub.get_phone_bo(+)',
4633: p_prefix=>l_debug_prefix,
4634: p_msg_level=>fnd_log.level_procedure);
4635: END IF;
4630: -- Debug info.
4631: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4632: hz_utility_v2pub.debug(p_message=>'hz_phone_bo_pub.get_phone_bo(+)',
4633: p_prefix=>l_debug_prefix,
4634: p_msg_level=>fnd_log.level_procedure);
4635: END IF;
4636:
4637: -- check if pass in contact_point_id and/or os+osr
4638: -- extraction validation logic is same as update
4671: END IF;
4672:
4673:
4674: -- Debug info.
4675: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
4676: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4677: p_msg_data=>x_msg_data,
4678: p_msg_type=>'WARNING',
4679: p_msg_level=>fnd_log.level_exception);
4675: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
4676: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4677: p_msg_data=>x_msg_data,
4678: p_msg_type=>'WARNING',
4679: p_msg_level=>fnd_log.level_exception);
4680: END IF;
4681:
4682: -- Debug info.
4683: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4679: p_msg_level=>fnd_log.level_exception);
4680: END IF;
4681:
4682: -- Debug info.
4683: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4684: hz_utility_v2pub.debug(p_message=>'hz_phone_bo_pub.get_phone_bo (-)',
4685: p_prefix=>l_debug_prefix,
4686: p_msg_level=>fnd_log.level_procedure);
4687: END IF;
4682: -- Debug info.
4683: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4684: hz_utility_v2pub.debug(p_message=>'hz_phone_bo_pub.get_phone_bo (-)',
4685: p_prefix=>l_debug_prefix,
4686: p_msg_level=>fnd_log.level_procedure);
4687: END IF;
4688:
4689:
4690: EXCEPTION
4696: p_count => x_msg_count,
4697: p_data => x_msg_data);
4698:
4699: -- Debug info.
4700: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4701: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4702: p_msg_data=>x_msg_data,
4703: p_msg_type=>'ERROR',
4704: p_msg_level=>fnd_log.level_error);
4700: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4701: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4702: p_msg_data=>x_msg_data,
4703: p_msg_type=>'ERROR',
4704: p_msg_level=>fnd_log.level_error);
4705: END IF;
4706: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4707: hz_utility_v2pub.debug(p_message=>'hz_phone_bo_pub.get_phone_bo (-)',
4708: p_prefix=>l_debug_prefix,
4702: p_msg_data=>x_msg_data,
4703: p_msg_type=>'ERROR',
4704: p_msg_level=>fnd_log.level_error);
4705: END IF;
4706: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4707: hz_utility_v2pub.debug(p_message=>'hz_phone_bo_pub.get_phone_bo (-)',
4708: p_prefix=>l_debug_prefix,
4709: p_msg_level=>fnd_log.level_procedure);
4710: END IF;
4705: END IF;
4706: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4707: hz_utility_v2pub.debug(p_message=>'hz_phone_bo_pub.get_phone_bo (-)',
4708: p_prefix=>l_debug_prefix,
4709: p_msg_level=>fnd_log.level_procedure);
4710: END IF;
4711: WHEN fnd_api.g_exc_unexpected_error THEN
4712: x_return_status := fnd_api.g_ret_sts_unexp_error;
4713:
4715: p_count => x_msg_count,
4716: p_data => x_msg_data);
4717:
4718: -- Debug info.
4719: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4720: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4721: p_msg_data=>x_msg_data,
4722: p_msg_type=>'UNEXPECTED ERROR',
4723: p_msg_level=>fnd_log.level_error);
4719: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4720: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4721: p_msg_data=>x_msg_data,
4722: p_msg_type=>'UNEXPECTED ERROR',
4723: p_msg_level=>fnd_log.level_error);
4724: END IF;
4725: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4726: hz_utility_v2pub.debug(p_message=>'hz_phone_bo_pub.get_phone_bo (-)',
4727: p_prefix=>l_debug_prefix,
4721: p_msg_data=>x_msg_data,
4722: p_msg_type=>'UNEXPECTED ERROR',
4723: p_msg_level=>fnd_log.level_error);
4724: END IF;
4725: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4726: hz_utility_v2pub.debug(p_message=>'hz_phone_bo_pub.get_phone_bo (-)',
4727: p_prefix=>l_debug_prefix,
4728: p_msg_level=>fnd_log.level_procedure);
4729: END IF;
4724: END IF;
4725: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4726: hz_utility_v2pub.debug(p_message=>'hz_phone_bo_pub.get_phone_bo (-)',
4727: p_prefix=>l_debug_prefix,
4728: p_msg_level=>fnd_log.level_procedure);
4729: END IF;
4730: WHEN OTHERS THEN
4731: x_return_status := fnd_api.g_ret_sts_unexp_error;
4732:
4738: p_count => x_msg_count,
4739: p_data => x_msg_data);
4740:
4741: -- Debug info.
4742: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4743: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4744: p_msg_data=>x_msg_data,
4745: p_msg_type=>'SQL ERROR',
4746: p_msg_level=>fnd_log.level_error);
4742: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4743: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4744: p_msg_data=>x_msg_data,
4745: p_msg_type=>'SQL ERROR',
4746: p_msg_level=>fnd_log.level_error);
4747: END IF;
4748: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4749: hz_utility_v2pub.debug(p_message=>'hz_phone_bo_pub.get_phone_bo (-)',
4750: p_prefix=>l_debug_prefix,
4744: p_msg_data=>x_msg_data,
4745: p_msg_type=>'SQL ERROR',
4746: p_msg_level=>fnd_log.level_error);
4747: END IF;
4748: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4749: hz_utility_v2pub.debug(p_message=>'hz_phone_bo_pub.get_phone_bo (-)',
4750: p_prefix=>l_debug_prefix,
4751: p_msg_level=>fnd_log.level_procedure);
4752: END IF;
4747: END IF;
4748: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4749: hz_utility_v2pub.debug(p_message=>'hz_phone_bo_pub.get_phone_bo (-)',
4750: p_prefix=>l_debug_prefix,
4751: p_msg_level=>fnd_log.level_procedure);
4752: END IF;
4753:
4754: end;
4755:
4840: END IF;
4841:
4842:
4843: -- Debug info.
4844: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4845: hz_utility_v2pub.debug(p_message=>'hz_telex_bo_pub.get_telex_bo(+)',
4846: p_prefix=>l_debug_prefix,
4847: p_msg_level=>fnd_log.level_procedure);
4848: END IF;
4843: -- Debug info.
4844: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4845: hz_utility_v2pub.debug(p_message=>'hz_telex_bo_pub.get_telex_bo(+)',
4846: p_prefix=>l_debug_prefix,
4847: p_msg_level=>fnd_log.level_procedure);
4848: END IF;
4849:
4850: -- check if pass in contact_point_id and/or os+osr
4851: -- extraction validation logic is same as update
4884: END IF;
4885:
4886:
4887: -- Debug info.
4888: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
4889: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4890: p_msg_data=>x_msg_data,
4891: p_msg_type=>'WARNING',
4892: p_msg_level=>fnd_log.level_exception);
4888: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
4889: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4890: p_msg_data=>x_msg_data,
4891: p_msg_type=>'WARNING',
4892: p_msg_level=>fnd_log.level_exception);
4893: END IF;
4894:
4895: -- Debug info.
4896: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4892: p_msg_level=>fnd_log.level_exception);
4893: END IF;
4894:
4895: -- Debug info.
4896: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4897: hz_utility_v2pub.debug(p_message=>'hz_telex_bo_pub.get_telex_bo (-)',
4898: p_prefix=>l_debug_prefix,
4899: p_msg_level=>fnd_log.level_procedure);
4900: END IF;
4895: -- Debug info.
4896: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4897: hz_utility_v2pub.debug(p_message=>'hz_telex_bo_pub.get_telex_bo (-)',
4898: p_prefix=>l_debug_prefix,
4899: p_msg_level=>fnd_log.level_procedure);
4900: END IF;
4901:
4902:
4903: EXCEPTION
4909: p_count => x_msg_count,
4910: p_data => x_msg_data);
4911:
4912: -- Debug info.
4913: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4914: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4915: p_msg_data=>x_msg_data,
4916: p_msg_type=>'ERROR',
4917: p_msg_level=>fnd_log.level_error);
4913: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4914: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4915: p_msg_data=>x_msg_data,
4916: p_msg_type=>'ERROR',
4917: p_msg_level=>fnd_log.level_error);
4918: END IF;
4919: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4920: hz_utility_v2pub.debug(p_message=>'hz_telex_bo_pub.get_telex_bo (-)',
4921: p_prefix=>l_debug_prefix,
4915: p_msg_data=>x_msg_data,
4916: p_msg_type=>'ERROR',
4917: p_msg_level=>fnd_log.level_error);
4918: END IF;
4919: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4920: hz_utility_v2pub.debug(p_message=>'hz_telex_bo_pub.get_telex_bo (-)',
4921: p_prefix=>l_debug_prefix,
4922: p_msg_level=>fnd_log.level_procedure);
4923: END IF;
4918: END IF;
4919: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4920: hz_utility_v2pub.debug(p_message=>'hz_telex_bo_pub.get_telex_bo (-)',
4921: p_prefix=>l_debug_prefix,
4922: p_msg_level=>fnd_log.level_procedure);
4923: END IF;
4924: WHEN fnd_api.g_exc_unexpected_error THEN
4925: x_return_status := fnd_api.g_ret_sts_unexp_error;
4926:
4928: p_count => x_msg_count,
4929: p_data => x_msg_data);
4930:
4931: -- Debug info.
4932: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4933: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4934: p_msg_data=>x_msg_data,
4935: p_msg_type=>'UNEXPECTED ERROR',
4936: p_msg_level=>fnd_log.level_error);
4932: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4933: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4934: p_msg_data=>x_msg_data,
4935: p_msg_type=>'UNEXPECTED ERROR',
4936: p_msg_level=>fnd_log.level_error);
4937: END IF;
4938: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4939: hz_utility_v2pub.debug(p_message=>'hz_telex_bo_pub.get_telex_bo (-)',
4940: p_prefix=>l_debug_prefix,
4934: p_msg_data=>x_msg_data,
4935: p_msg_type=>'UNEXPECTED ERROR',
4936: p_msg_level=>fnd_log.level_error);
4937: END IF;
4938: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4939: hz_utility_v2pub.debug(p_message=>'hz_telex_bo_pub.get_telex_bo (-)',
4940: p_prefix=>l_debug_prefix,
4941: p_msg_level=>fnd_log.level_procedure);
4942: END IF;
4937: END IF;
4938: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4939: hz_utility_v2pub.debug(p_message=>'hz_telex_bo_pub.get_telex_bo (-)',
4940: p_prefix=>l_debug_prefix,
4941: p_msg_level=>fnd_log.level_procedure);
4942: END IF;
4943: WHEN OTHERS THEN
4944: x_return_status := fnd_api.g_ret_sts_unexp_error;
4945:
4951: p_count => x_msg_count,
4952: p_data => x_msg_data);
4953:
4954: -- Debug info.
4955: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4956: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4957: p_msg_data=>x_msg_data,
4958: p_msg_type=>'SQL ERROR',
4959: p_msg_level=>fnd_log.level_error);
4955: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4956: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4957: p_msg_data=>x_msg_data,
4958: p_msg_type=>'SQL ERROR',
4959: p_msg_level=>fnd_log.level_error);
4960: END IF;
4961: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4962: hz_utility_v2pub.debug(p_message=>'hz_telex_bo_pub.get_telex_bo (-)',
4963: p_prefix=>l_debug_prefix,
4957: p_msg_data=>x_msg_data,
4958: p_msg_type=>'SQL ERROR',
4959: p_msg_level=>fnd_log.level_error);
4960: END IF;
4961: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4962: hz_utility_v2pub.debug(p_message=>'hz_telex_bo_pub.get_telex_bo (-)',
4963: p_prefix=>l_debug_prefix,
4964: p_msg_level=>fnd_log.level_procedure);
4965: END IF;
4960: END IF;
4961: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4962: hz_utility_v2pub.debug(p_message=>'hz_telex_bo_pub.get_telex_bo (-)',
4963: p_prefix=>l_debug_prefix,
4964: p_msg_level=>fnd_log.level_procedure);
4965: END IF;
4966:
4967: end;
4968:
5053: END IF;
5054:
5055:
5056: -- Debug info.
5057: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5058: hz_utility_v2pub.debug(p_message=>'hz_email_bo_pub.get_email_bo(+)',
5059: p_prefix=>l_debug_prefix,
5060: p_msg_level=>fnd_log.level_procedure);
5061: END IF;
5056: -- Debug info.
5057: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5058: hz_utility_v2pub.debug(p_message=>'hz_email_bo_pub.get_email_bo(+)',
5059: p_prefix=>l_debug_prefix,
5060: p_msg_level=>fnd_log.level_procedure);
5061: END IF;
5062:
5063: -- check if pass in contact_point_id and/or os+osr
5064: -- extraction validation logic is same as update
5097: END IF;
5098:
5099:
5100: -- Debug info.
5101: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
5102: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5103: p_msg_data=>x_msg_data,
5104: p_msg_type=>'WARNING',
5105: p_msg_level=>fnd_log.level_exception);
5101: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
5102: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5103: p_msg_data=>x_msg_data,
5104: p_msg_type=>'WARNING',
5105: p_msg_level=>fnd_log.level_exception);
5106: END IF;
5107:
5108: -- Debug info.
5109: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5105: p_msg_level=>fnd_log.level_exception);
5106: END IF;
5107:
5108: -- Debug info.
5109: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5110: hz_utility_v2pub.debug(p_message=>'hz_email_bo_pub.get_email_bo (-)',
5111: p_prefix=>l_debug_prefix,
5112: p_msg_level=>fnd_log.level_procedure);
5113: END IF;
5108: -- Debug info.
5109: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5110: hz_utility_v2pub.debug(p_message=>'hz_email_bo_pub.get_email_bo (-)',
5111: p_prefix=>l_debug_prefix,
5112: p_msg_level=>fnd_log.level_procedure);
5113: END IF;
5114:
5115:
5116: EXCEPTION
5122: p_count => x_msg_count,
5123: p_data => x_msg_data);
5124:
5125: -- Debug info.
5126: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5127: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5128: p_msg_data=>x_msg_data,
5129: p_msg_type=>'ERROR',
5130: p_msg_level=>fnd_log.level_error);
5126: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5127: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5128: p_msg_data=>x_msg_data,
5129: p_msg_type=>'ERROR',
5130: p_msg_level=>fnd_log.level_error);
5131: END IF;
5132: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5133: hz_utility_v2pub.debug(p_message=>'hz_email_bo_pub.get_email_bo (-)',
5134: p_prefix=>l_debug_prefix,
5128: p_msg_data=>x_msg_data,
5129: p_msg_type=>'ERROR',
5130: p_msg_level=>fnd_log.level_error);
5131: END IF;
5132: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5133: hz_utility_v2pub.debug(p_message=>'hz_email_bo_pub.get_email_bo (-)',
5134: p_prefix=>l_debug_prefix,
5135: p_msg_level=>fnd_log.level_procedure);
5136: END IF;
5131: END IF;
5132: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5133: hz_utility_v2pub.debug(p_message=>'hz_email_bo_pub.get_email_bo (-)',
5134: p_prefix=>l_debug_prefix,
5135: p_msg_level=>fnd_log.level_procedure);
5136: END IF;
5137: WHEN fnd_api.g_exc_unexpected_error THEN
5138: x_return_status := fnd_api.g_ret_sts_unexp_error;
5139:
5141: p_count => x_msg_count,
5142: p_data => x_msg_data);
5143:
5144: -- Debug info.
5145: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5146: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5147: p_msg_data=>x_msg_data,
5148: p_msg_type=>'UNEXPECTED ERROR',
5149: p_msg_level=>fnd_log.level_error);
5145: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5146: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5147: p_msg_data=>x_msg_data,
5148: p_msg_type=>'UNEXPECTED ERROR',
5149: p_msg_level=>fnd_log.level_error);
5150: END IF;
5151: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5152: hz_utility_v2pub.debug(p_message=>'hz_email_bo_pub.get_email_bo (-)',
5153: p_prefix=>l_debug_prefix,
5147: p_msg_data=>x_msg_data,
5148: p_msg_type=>'UNEXPECTED ERROR',
5149: p_msg_level=>fnd_log.level_error);
5150: END IF;
5151: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5152: hz_utility_v2pub.debug(p_message=>'hz_email_bo_pub.get_email_bo (-)',
5153: p_prefix=>l_debug_prefix,
5154: p_msg_level=>fnd_log.level_procedure);
5155: END IF;
5150: END IF;
5151: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5152: hz_utility_v2pub.debug(p_message=>'hz_email_bo_pub.get_email_bo (-)',
5153: p_prefix=>l_debug_prefix,
5154: p_msg_level=>fnd_log.level_procedure);
5155: END IF;
5156: WHEN OTHERS THEN
5157: x_return_status := fnd_api.g_ret_sts_unexp_error;
5158:
5164: p_count => x_msg_count,
5165: p_data => x_msg_data);
5166:
5167: -- Debug info.
5168: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5169: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5170: p_msg_data=>x_msg_data,
5171: p_msg_type=>'SQL ERROR',
5172: p_msg_level=>fnd_log.level_error);
5168: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5169: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5170: p_msg_data=>x_msg_data,
5171: p_msg_type=>'SQL ERROR',
5172: p_msg_level=>fnd_log.level_error);
5173: END IF;
5174: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5175: hz_utility_v2pub.debug(p_message=>'hz_email_bo_pub.get_email_bo (-)',
5176: p_prefix=>l_debug_prefix,
5170: p_msg_data=>x_msg_data,
5171: p_msg_type=>'SQL ERROR',
5172: p_msg_level=>fnd_log.level_error);
5173: END IF;
5174: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5175: hz_utility_v2pub.debug(p_message=>'hz_email_bo_pub.get_email_bo (-)',
5176: p_prefix=>l_debug_prefix,
5177: p_msg_level=>fnd_log.level_procedure);
5178: END IF;
5173: END IF;
5174: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5175: hz_utility_v2pub.debug(p_message=>'hz_email_bo_pub.get_email_bo (-)',
5176: p_prefix=>l_debug_prefix,
5177: p_msg_level=>fnd_log.level_procedure);
5178: END IF;
5179:
5180: end;
5181:
5266: END IF;
5267:
5268:
5269: -- Debug info.
5270: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5271: hz_utility_v2pub.debug(p_message=>'hz_web_bo_pub.get_web_bo(+)',
5272: p_prefix=>l_debug_prefix,
5273: p_msg_level=>fnd_log.level_procedure);
5274: END IF;
5269: -- Debug info.
5270: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5271: hz_utility_v2pub.debug(p_message=>'hz_web_bo_pub.get_web_bo(+)',
5272: p_prefix=>l_debug_prefix,
5273: p_msg_level=>fnd_log.level_procedure);
5274: END IF;
5275:
5276: -- check if pass in contact_point_id and/or os+osr
5277: -- extraction validation logic is same as update
5310: END IF;
5311:
5312:
5313: -- Debug info.
5314: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
5315: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5316: p_msg_data=>x_msg_data,
5317: p_msg_type=>'WARNING',
5318: p_msg_level=>fnd_log.level_exception);
5314: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
5315: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5316: p_msg_data=>x_msg_data,
5317: p_msg_type=>'WARNING',
5318: p_msg_level=>fnd_log.level_exception);
5319: END IF;
5320:
5321: -- Debug info.
5322: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5318: p_msg_level=>fnd_log.level_exception);
5319: END IF;
5320:
5321: -- Debug info.
5322: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5323: hz_utility_v2pub.debug(p_message=>'hz_web_bo_pub.get_web_bo (-)',
5324: p_prefix=>l_debug_prefix,
5325: p_msg_level=>fnd_log.level_procedure);
5326: END IF;
5321: -- Debug info.
5322: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5323: hz_utility_v2pub.debug(p_message=>'hz_web_bo_pub.get_web_bo (-)',
5324: p_prefix=>l_debug_prefix,
5325: p_msg_level=>fnd_log.level_procedure);
5326: END IF;
5327:
5328:
5329: EXCEPTION
5335: p_count => x_msg_count,
5336: p_data => x_msg_data);
5337:
5338: -- Debug info.
5339: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5340: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5341: p_msg_data=>x_msg_data,
5342: p_msg_type=>'ERROR',
5343: p_msg_level=>fnd_log.level_error);
5339: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5340: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5341: p_msg_data=>x_msg_data,
5342: p_msg_type=>'ERROR',
5343: p_msg_level=>fnd_log.level_error);
5344: END IF;
5345: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5346: hz_utility_v2pub.debug(p_message=>'hz_web_bo_pub.get_web_bo (-)',
5347: p_prefix=>l_debug_prefix,
5341: p_msg_data=>x_msg_data,
5342: p_msg_type=>'ERROR',
5343: p_msg_level=>fnd_log.level_error);
5344: END IF;
5345: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5346: hz_utility_v2pub.debug(p_message=>'hz_web_bo_pub.get_web_bo (-)',
5347: p_prefix=>l_debug_prefix,
5348: p_msg_level=>fnd_log.level_procedure);
5349: END IF;
5344: END IF;
5345: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5346: hz_utility_v2pub.debug(p_message=>'hz_web_bo_pub.get_web_bo (-)',
5347: p_prefix=>l_debug_prefix,
5348: p_msg_level=>fnd_log.level_procedure);
5349: END IF;
5350: WHEN fnd_api.g_exc_unexpected_error THEN
5351: x_return_status := fnd_api.g_ret_sts_unexp_error;
5352:
5354: p_count => x_msg_count,
5355: p_data => x_msg_data);
5356:
5357: -- Debug info.
5358: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5359: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5360: p_msg_data=>x_msg_data,
5361: p_msg_type=>'UNEXPECTED ERROR',
5362: p_msg_level=>fnd_log.level_error);
5358: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5359: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5360: p_msg_data=>x_msg_data,
5361: p_msg_type=>'UNEXPECTED ERROR',
5362: p_msg_level=>fnd_log.level_error);
5363: END IF;
5364: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5365: hz_utility_v2pub.debug(p_message=>'hz_web_bo_pub.get_web_bo (-)',
5366: p_prefix=>l_debug_prefix,
5360: p_msg_data=>x_msg_data,
5361: p_msg_type=>'UNEXPECTED ERROR',
5362: p_msg_level=>fnd_log.level_error);
5363: END IF;
5364: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5365: hz_utility_v2pub.debug(p_message=>'hz_web_bo_pub.get_web_bo (-)',
5366: p_prefix=>l_debug_prefix,
5367: p_msg_level=>fnd_log.level_procedure);
5368: END IF;
5363: END IF;
5364: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5365: hz_utility_v2pub.debug(p_message=>'hz_web_bo_pub.get_web_bo (-)',
5366: p_prefix=>l_debug_prefix,
5367: p_msg_level=>fnd_log.level_procedure);
5368: END IF;
5369: WHEN OTHERS THEN
5370: x_return_status := fnd_api.g_ret_sts_unexp_error;
5371:
5377: p_count => x_msg_count,
5378: p_data => x_msg_data);
5379:
5380: -- Debug info.
5381: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5382: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5383: p_msg_data=>x_msg_data,
5384: p_msg_type=>'SQL ERROR',
5385: p_msg_level=>fnd_log.level_error);
5381: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5382: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5383: p_msg_data=>x_msg_data,
5384: p_msg_type=>'SQL ERROR',
5385: p_msg_level=>fnd_log.level_error);
5386: END IF;
5387: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5388: hz_utility_v2pub.debug(p_message=>'hz_web_bo_pub.get_web_bo (-)',
5389: p_prefix=>l_debug_prefix,
5383: p_msg_data=>x_msg_data,
5384: p_msg_type=>'SQL ERROR',
5385: p_msg_level=>fnd_log.level_error);
5386: END IF;
5387: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5388: hz_utility_v2pub.debug(p_message=>'hz_web_bo_pub.get_web_bo (-)',
5389: p_prefix=>l_debug_prefix,
5390: p_msg_level=>fnd_log.level_procedure);
5391: END IF;
5386: END IF;
5387: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5388: hz_utility_v2pub.debug(p_message=>'hz_web_bo_pub.get_web_bo (-)',
5389: p_prefix=>l_debug_prefix,
5390: p_msg_level=>fnd_log.level_procedure);
5391: END IF;
5392:
5393: end;
5394:
5478: END IF;
5479:
5480:
5481: -- Debug info.
5482: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5483: hz_utility_v2pub.debug(p_message=>'hz_edi_bo_pub.get_edi_bo(+)',
5484: p_prefix=>l_debug_prefix,
5485: p_msg_level=>fnd_log.level_procedure);
5486: END IF;
5481: -- Debug info.
5482: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5483: hz_utility_v2pub.debug(p_message=>'hz_edi_bo_pub.get_edi_bo(+)',
5484: p_prefix=>l_debug_prefix,
5485: p_msg_level=>fnd_log.level_procedure);
5486: END IF;
5487:
5488: -- check if pass in contact_point_id and/or os+osr
5489: -- extraction validation logic is same as update
5522: END IF;
5523:
5524:
5525: -- Debug info.
5526: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
5527: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5528: p_msg_data=>x_msg_data,
5529: p_msg_type=>'WARNING',
5530: p_msg_level=>fnd_log.level_exception);
5526: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
5527: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5528: p_msg_data=>x_msg_data,
5529: p_msg_type=>'WARNING',
5530: p_msg_level=>fnd_log.level_exception);
5531: END IF;
5532:
5533: -- Debug info.
5534: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5530: p_msg_level=>fnd_log.level_exception);
5531: END IF;
5532:
5533: -- Debug info.
5534: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5535: hz_utility_v2pub.debug(p_message=>'hz_edi_bo_pub.get_edi_bo (-)',
5536: p_prefix=>l_debug_prefix,
5537: p_msg_level=>fnd_log.level_procedure);
5538: END IF;
5533: -- Debug info.
5534: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5535: hz_utility_v2pub.debug(p_message=>'hz_edi_bo_pub.get_edi_bo (-)',
5536: p_prefix=>l_debug_prefix,
5537: p_msg_level=>fnd_log.level_procedure);
5538: END IF;
5539:
5540:
5541: EXCEPTION
5547: p_count => x_msg_count,
5548: p_data => x_msg_data);
5549:
5550: -- Debug info.
5551: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5552: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5553: p_msg_data=>x_msg_data,
5554: p_msg_type=>'ERROR',
5555: p_msg_level=>fnd_log.level_error);
5551: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5552: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5553: p_msg_data=>x_msg_data,
5554: p_msg_type=>'ERROR',
5555: p_msg_level=>fnd_log.level_error);
5556: END IF;
5557: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5558: hz_utility_v2pub.debug(p_message=>'hz_edi_bo_pub.get_edi_bo (-)',
5559: p_prefix=>l_debug_prefix,
5553: p_msg_data=>x_msg_data,
5554: p_msg_type=>'ERROR',
5555: p_msg_level=>fnd_log.level_error);
5556: END IF;
5557: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5558: hz_utility_v2pub.debug(p_message=>'hz_edi_bo_pub.get_edi_bo (-)',
5559: p_prefix=>l_debug_prefix,
5560: p_msg_level=>fnd_log.level_procedure);
5561: END IF;
5556: END IF;
5557: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5558: hz_utility_v2pub.debug(p_message=>'hz_edi_bo_pub.get_edi_bo (-)',
5559: p_prefix=>l_debug_prefix,
5560: p_msg_level=>fnd_log.level_procedure);
5561: END IF;
5562: WHEN fnd_api.g_exc_unexpected_error THEN
5563: x_return_status := fnd_api.g_ret_sts_unexp_error;
5564:
5566: p_count => x_msg_count,
5567: p_data => x_msg_data);
5568:
5569: -- Debug info.
5570: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5571: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5572: p_msg_data=>x_msg_data,
5573: p_msg_type=>'UNEXPECTED ERROR',
5574: p_msg_level=>fnd_log.level_error);
5570: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5571: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5572: p_msg_data=>x_msg_data,
5573: p_msg_type=>'UNEXPECTED ERROR',
5574: p_msg_level=>fnd_log.level_error);
5575: END IF;
5576: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5577: hz_utility_v2pub.debug(p_message=>'hz_edi_bo_pub.get_edi_bo (-)',
5578: p_prefix=>l_debug_prefix,
5572: p_msg_data=>x_msg_data,
5573: p_msg_type=>'UNEXPECTED ERROR',
5574: p_msg_level=>fnd_log.level_error);
5575: END IF;
5576: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5577: hz_utility_v2pub.debug(p_message=>'hz_edi_bo_pub.get_edi_bo (-)',
5578: p_prefix=>l_debug_prefix,
5579: p_msg_level=>fnd_log.level_procedure);
5580: END IF;
5575: END IF;
5576: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5577: hz_utility_v2pub.debug(p_message=>'hz_edi_bo_pub.get_edi_bo (-)',
5578: p_prefix=>l_debug_prefix,
5579: p_msg_level=>fnd_log.level_procedure);
5580: END IF;
5581: WHEN OTHERS THEN
5582: x_return_status := fnd_api.g_ret_sts_unexp_error;
5583:
5589: p_count => x_msg_count,
5590: p_data => x_msg_data);
5591:
5592: -- Debug info.
5593: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5594: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5595: p_msg_data=>x_msg_data,
5596: p_msg_type=>'SQL ERROR',
5597: p_msg_level=>fnd_log.level_error);
5593: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5594: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5595: p_msg_data=>x_msg_data,
5596: p_msg_type=>'SQL ERROR',
5597: p_msg_level=>fnd_log.level_error);
5598: END IF;
5599: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5600: hz_utility_v2pub.debug(p_message=>'hz_edi_bo_pub.get_edi_bo (-)',
5601: p_prefix=>l_debug_prefix,
5595: p_msg_data=>x_msg_data,
5596: p_msg_type=>'SQL ERROR',
5597: p_msg_level=>fnd_log.level_error);
5598: END IF;
5599: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5600: hz_utility_v2pub.debug(p_message=>'hz_edi_bo_pub.get_edi_bo (-)',
5601: p_prefix=>l_debug_prefix,
5602: p_msg_level=>fnd_log.level_procedure);
5603: END IF;
5598: END IF;
5599: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5600: hz_utility_v2pub.debug(p_message=>'hz_edi_bo_pub.get_edi_bo (-)',
5601: p_prefix=>l_debug_prefix,
5602: p_msg_level=>fnd_log.level_procedure);
5603: END IF;
5604:
5605: end;
5606:
5691: END IF;
5692:
5693:
5694: -- Debug info.
5695: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5696: hz_utility_v2pub.debug(p_message=>'hz_eft_bo_pub.get_eft_bo(+)',
5697: p_prefix=>l_debug_prefix,
5698: p_msg_level=>fnd_log.level_procedure);
5699: END IF;
5694: -- Debug info.
5695: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5696: hz_utility_v2pub.debug(p_message=>'hz_eft_bo_pub.get_eft_bo(+)',
5697: p_prefix=>l_debug_prefix,
5698: p_msg_level=>fnd_log.level_procedure);
5699: END IF;
5700:
5701: -- check if pass in contact_point_id and/or os+osr
5702: -- extraction validation logic is same as update
5735: END IF;
5736:
5737:
5738: -- Debug info.
5739: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
5740: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5741: p_msg_data=>x_msg_data,
5742: p_msg_type=>'WARNING',
5743: p_msg_level=>fnd_log.level_exception);
5739: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
5740: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5741: p_msg_data=>x_msg_data,
5742: p_msg_type=>'WARNING',
5743: p_msg_level=>fnd_log.level_exception);
5744: END IF;
5745:
5746: -- Debug info.
5747: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5743: p_msg_level=>fnd_log.level_exception);
5744: END IF;
5745:
5746: -- Debug info.
5747: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5748: hz_utility_v2pub.debug(p_message=>'hz_eft_bo_pub.get_eft_bo (-)',
5749: p_prefix=>l_debug_prefix,
5750: p_msg_level=>fnd_log.level_procedure);
5751: END IF;
5746: -- Debug info.
5747: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5748: hz_utility_v2pub.debug(p_message=>'hz_eft_bo_pub.get_eft_bo (-)',
5749: p_prefix=>l_debug_prefix,
5750: p_msg_level=>fnd_log.level_procedure);
5751: END IF;
5752:
5753:
5754: EXCEPTION
5760: p_count => x_msg_count,
5761: p_data => x_msg_data);
5762:
5763: -- Debug info.
5764: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5765: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5766: p_msg_data=>x_msg_data,
5767: p_msg_type=>'ERROR',
5768: p_msg_level=>fnd_log.level_error);
5764: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5765: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5766: p_msg_data=>x_msg_data,
5767: p_msg_type=>'ERROR',
5768: p_msg_level=>fnd_log.level_error);
5769: END IF;
5770: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5771: hz_utility_v2pub.debug(p_message=>'hz_eft_bo_pub.get_eft_bo (-)',
5772: p_prefix=>l_debug_prefix,
5766: p_msg_data=>x_msg_data,
5767: p_msg_type=>'ERROR',
5768: p_msg_level=>fnd_log.level_error);
5769: END IF;
5770: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5771: hz_utility_v2pub.debug(p_message=>'hz_eft_bo_pub.get_eft_bo (-)',
5772: p_prefix=>l_debug_prefix,
5773: p_msg_level=>fnd_log.level_procedure);
5774: END IF;
5769: END IF;
5770: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5771: hz_utility_v2pub.debug(p_message=>'hz_eft_bo_pub.get_eft_bo (-)',
5772: p_prefix=>l_debug_prefix,
5773: p_msg_level=>fnd_log.level_procedure);
5774: END IF;
5775: WHEN fnd_api.g_exc_unexpected_error THEN
5776: x_return_status := fnd_api.g_ret_sts_unexp_error;
5777:
5779: p_count => x_msg_count,
5780: p_data => x_msg_data);
5781:
5782: -- Debug info.
5783: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5784: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5785: p_msg_data=>x_msg_data,
5786: p_msg_type=>'UNEXPECTED ERROR',
5787: p_msg_level=>fnd_log.level_error);
5783: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5784: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5785: p_msg_data=>x_msg_data,
5786: p_msg_type=>'UNEXPECTED ERROR',
5787: p_msg_level=>fnd_log.level_error);
5788: END IF;
5789: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5790: hz_utility_v2pub.debug(p_message=>'hz_eft_bo_pub.get_eft_bo (-)',
5791: p_prefix=>l_debug_prefix,
5785: p_msg_data=>x_msg_data,
5786: p_msg_type=>'UNEXPECTED ERROR',
5787: p_msg_level=>fnd_log.level_error);
5788: END IF;
5789: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5790: hz_utility_v2pub.debug(p_message=>'hz_eft_bo_pub.get_eft_bo (-)',
5791: p_prefix=>l_debug_prefix,
5792: p_msg_level=>fnd_log.level_procedure);
5793: END IF;
5788: END IF;
5789: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5790: hz_utility_v2pub.debug(p_message=>'hz_eft_bo_pub.get_eft_bo (-)',
5791: p_prefix=>l_debug_prefix,
5792: p_msg_level=>fnd_log.level_procedure);
5793: END IF;
5794: WHEN OTHERS THEN
5795: x_return_status := fnd_api.g_ret_sts_unexp_error;
5796:
5802: p_count => x_msg_count,
5803: p_data => x_msg_data);
5804:
5805: -- Debug info.
5806: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5807: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5808: p_msg_data=>x_msg_data,
5809: p_msg_type=>'SQL ERROR',
5810: p_msg_level=>fnd_log.level_error);
5806: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5807: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5808: p_msg_data=>x_msg_data,
5809: p_msg_type=>'SQL ERROR',
5810: p_msg_level=>fnd_log.level_error);
5811: END IF;
5812: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5813: hz_utility_v2pub.debug(p_message=>'hz_eft_bo_pub.get_eft_bo (-)',
5814: p_prefix=>l_debug_prefix,
5808: p_msg_data=>x_msg_data,
5809: p_msg_type=>'SQL ERROR',
5810: p_msg_level=>fnd_log.level_error);
5811: END IF;
5812: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5813: hz_utility_v2pub.debug(p_message=>'hz_eft_bo_pub.get_eft_bo (-)',
5814: p_prefix=>l_debug_prefix,
5815: p_msg_level=>fnd_log.level_procedure);
5816: END IF;
5811: END IF;
5812: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5813: hz_utility_v2pub.debug(p_message=>'hz_eft_bo_pub.get_eft_bo (-)',
5814: p_prefix=>l_debug_prefix,
5815: p_msg_level=>fnd_log.level_procedure);
5816: END IF;
5817:
5818: end;
5819:
5904: END IF;
5905:
5906:
5907: -- Debug info.
5908: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5909: hz_utility_v2pub.debug(p_message=>'hz_sms_bo_pub.get_sms_bo(+)',
5910: p_prefix=>l_debug_prefix,
5911: p_msg_level=>fnd_log.level_procedure);
5912: END IF;
5907: -- Debug info.
5908: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5909: hz_utility_v2pub.debug(p_message=>'hz_sms_bo_pub.get_sms_bo(+)',
5910: p_prefix=>l_debug_prefix,
5911: p_msg_level=>fnd_log.level_procedure);
5912: END IF;
5913:
5914: -- check if pass in contact_point_id and/or os+osr
5915: -- extraction validation logic is same as update
5948: END IF;
5949:
5950:
5951: -- Debug info.
5952: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
5953: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5954: p_msg_data=>x_msg_data,
5955: p_msg_type=>'WARNING',
5956: p_msg_level=>fnd_log.level_exception);
5952: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
5953: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5954: p_msg_data=>x_msg_data,
5955: p_msg_type=>'WARNING',
5956: p_msg_level=>fnd_log.level_exception);
5957: END IF;
5958:
5959: -- Debug info.
5960: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5956: p_msg_level=>fnd_log.level_exception);
5957: END IF;
5958:
5959: -- Debug info.
5960: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5961: hz_utility_v2pub.debug(p_message=>'hz_sms_bo_pub.get_sms_bo (-)',
5962: p_prefix=>l_debug_prefix,
5963: p_msg_level=>fnd_log.level_procedure);
5964: END IF;
5959: -- Debug info.
5960: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5961: hz_utility_v2pub.debug(p_message=>'hz_sms_bo_pub.get_sms_bo (-)',
5962: p_prefix=>l_debug_prefix,
5963: p_msg_level=>fnd_log.level_procedure);
5964: END IF;
5965:
5966:
5967: EXCEPTION
5973: p_count => x_msg_count,
5974: p_data => x_msg_data);
5975:
5976: -- Debug info.
5977: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5978: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5979: p_msg_data=>x_msg_data,
5980: p_msg_type=>'ERROR',
5981: p_msg_level=>fnd_log.level_error);
5977: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5978: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5979: p_msg_data=>x_msg_data,
5980: p_msg_type=>'ERROR',
5981: p_msg_level=>fnd_log.level_error);
5982: END IF;
5983: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5984: hz_utility_v2pub.debug(p_message=>'hz_sms_bo_pub.get_sms_bo (-)',
5985: p_prefix=>l_debug_prefix,
5979: p_msg_data=>x_msg_data,
5980: p_msg_type=>'ERROR',
5981: p_msg_level=>fnd_log.level_error);
5982: END IF;
5983: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5984: hz_utility_v2pub.debug(p_message=>'hz_sms_bo_pub.get_sms_bo (-)',
5985: p_prefix=>l_debug_prefix,
5986: p_msg_level=>fnd_log.level_procedure);
5987: END IF;
5982: END IF;
5983: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5984: hz_utility_v2pub.debug(p_message=>'hz_sms_bo_pub.get_sms_bo (-)',
5985: p_prefix=>l_debug_prefix,
5986: p_msg_level=>fnd_log.level_procedure);
5987: END IF;
5988: WHEN fnd_api.g_exc_unexpected_error THEN
5989: x_return_status := fnd_api.g_ret_sts_unexp_error;
5990:
5992: p_count => x_msg_count,
5993: p_data => x_msg_data);
5994:
5995: -- Debug info.
5996: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5997: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5998: p_msg_data=>x_msg_data,
5999: p_msg_type=>'UNEXPECTED ERROR',
6000: p_msg_level=>fnd_log.level_error);
5996: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5997: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5998: p_msg_data=>x_msg_data,
5999: p_msg_type=>'UNEXPECTED ERROR',
6000: p_msg_level=>fnd_log.level_error);
6001: END IF;
6002: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6003: hz_utility_v2pub.debug(p_message=>'hz_sms_bo_pub.get_sms_bo (-)',
6004: p_prefix=>l_debug_prefix,
5998: p_msg_data=>x_msg_data,
5999: p_msg_type=>'UNEXPECTED ERROR',
6000: p_msg_level=>fnd_log.level_error);
6001: END IF;
6002: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6003: hz_utility_v2pub.debug(p_message=>'hz_sms_bo_pub.get_sms_bo (-)',
6004: p_prefix=>l_debug_prefix,
6005: p_msg_level=>fnd_log.level_procedure);
6006: END IF;
6001: END IF;
6002: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6003: hz_utility_v2pub.debug(p_message=>'hz_sms_bo_pub.get_sms_bo (-)',
6004: p_prefix=>l_debug_prefix,
6005: p_msg_level=>fnd_log.level_procedure);
6006: END IF;
6007: WHEN OTHERS THEN
6008: x_return_status := fnd_api.g_ret_sts_unexp_error;
6009:
6015: p_count => x_msg_count,
6016: p_data => x_msg_data);
6017:
6018: -- Debug info.
6019: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6020: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6021: p_msg_data=>x_msg_data,
6022: p_msg_type=>'SQL ERROR',
6023: p_msg_level=>fnd_log.level_error);
6019: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6020: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6021: p_msg_data=>x_msg_data,
6022: p_msg_type=>'SQL ERROR',
6023: p_msg_level=>fnd_log.level_error);
6024: END IF;
6025: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6026: hz_utility_v2pub.debug(p_message=>'hz_sms_bo_pub.get_sms_bo (-)',
6027: p_prefix=>l_debug_prefix,
6021: p_msg_data=>x_msg_data,
6022: p_msg_type=>'SQL ERROR',
6023: p_msg_level=>fnd_log.level_error);
6024: END IF;
6025: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6026: hz_utility_v2pub.debug(p_message=>'hz_sms_bo_pub.get_sms_bo (-)',
6027: p_prefix=>l_debug_prefix,
6028: p_msg_level=>fnd_log.level_procedure);
6029: END IF;
6024: END IF;
6025: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6026: hz_utility_v2pub.debug(p_message=>'hz_sms_bo_pub.get_sms_bo (-)',
6027: p_prefix=>l_debug_prefix,
6028: p_msg_level=>fnd_log.level_procedure);
6029: END IF;
6030:
6031: end;
6032: