DBA Data[Home] [Help]

APPS.HZ_CONTACT_POINT_BO_PUB dependencies on FND_LOG

Line 1734: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 1737: p_msg_level=>fnd_log.level_procedure);

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

Line 1997: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level 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);

Line 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,

Line 2003: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 2006: p_msg_level=>fnd_log.level_procedure);

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

Line 2028: IF fnd_log.level_error>=fnd_log.g_current_runtime_level 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);

Line 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,

Line 2034: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 2037: p_msg_level=>fnd_log.level_procedure);

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;

Line 2058: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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);

Line 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,

Line 2064: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 2067: p_msg_level=>fnd_log.level_procedure);

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;

Line 2092: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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);

Line 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,

Line 2098: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 2101: p_msg_level=>fnd_log.level_procedure);

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

Line 2815: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 2818: p_msg_level=>fnd_log.level_procedure);

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;

Line 3052: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

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);

Line 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,

Line 3058: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 3061: p_msg_level=>fnd_log.level_procedure);

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

Line 3083: IF fnd_log.level_error>=fnd_log.g_current_runtime_level 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);

Line 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,

Line 3089: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 3092: p_msg_level=>fnd_log.level_procedure);

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;

Line 3113: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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);

Line 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,

Line 3119: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 3122: p_msg_level=>fnd_log.level_procedure);

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;

Line 3147: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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);

Line 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,

Line 3153: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 3156: p_msg_level=>fnd_log.level_procedure);

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

Line 3999: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 4002: p_msg_level=>fnd_log.level_procedure);

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';

Line 4435: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

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);

Line 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,

Line 4441: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 4444: p_msg_level=>fnd_log.level_procedure);

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

Line 4460: IF fnd_log.level_error>=fnd_log.g_current_runtime_level 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);

Line 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,

Line 4466: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 4469: p_msg_level=>fnd_log.level_procedure);

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

Line 4484: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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);

Line 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,

Line 4490: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 4493: p_msg_level=>fnd_log.level_procedure);

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;

Line 4511: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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);

Line 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,

Line 4517: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 4520: p_msg_level=>fnd_log.level_procedure);

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: /*

Line 4631: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 4634: p_msg_level=>fnd_log.level_procedure);

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

Line 4675: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

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);

Line 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

Line 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;

Line 4686: p_msg_level=>fnd_log.level_procedure);

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

Line 4700: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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);

Line 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,

Line 4706: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 4709: p_msg_level=>fnd_log.level_procedure);

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:

Line 4719: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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);

Line 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,

Line 4725: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 4728: p_msg_level=>fnd_log.level_procedure);

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:

Line 4742: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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);

Line 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,

Line 4748: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 4751: p_msg_level=>fnd_log.level_procedure);

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:

Line 4844: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 4847: p_msg_level=>fnd_log.level_procedure);

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

Line 4888: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

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);

Line 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

Line 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;

Line 4899: p_msg_level=>fnd_log.level_procedure);

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

Line 4913: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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);

Line 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,

Line 4919: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 4922: p_msg_level=>fnd_log.level_procedure);

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:

Line 4932: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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);

Line 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,

Line 4938: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 4941: p_msg_level=>fnd_log.level_procedure);

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:

Line 4955: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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);

Line 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,

Line 4961: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 4964: p_msg_level=>fnd_log.level_procedure);

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:

Line 5057: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 5060: p_msg_level=>fnd_log.level_procedure);

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

Line 5101: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

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);

Line 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

Line 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;

Line 5112: p_msg_level=>fnd_log.level_procedure);

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

Line 5126: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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);

Line 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,

Line 5132: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 5135: p_msg_level=>fnd_log.level_procedure);

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:

Line 5145: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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);

Line 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,

Line 5151: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 5154: p_msg_level=>fnd_log.level_procedure);

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:

Line 5168: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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);

Line 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,

Line 5174: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 5177: p_msg_level=>fnd_log.level_procedure);

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:

Line 5270: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 5273: p_msg_level=>fnd_log.level_procedure);

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

Line 5314: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

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);

Line 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

Line 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;

Line 5325: p_msg_level=>fnd_log.level_procedure);

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

Line 5339: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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);

Line 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,

Line 5345: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 5348: p_msg_level=>fnd_log.level_procedure);

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:

Line 5358: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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);

Line 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,

Line 5364: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 5367: p_msg_level=>fnd_log.level_procedure);

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:

Line 5381: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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);

Line 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,

Line 5387: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 5390: p_msg_level=>fnd_log.level_procedure);

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:

Line 5482: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 5485: p_msg_level=>fnd_log.level_procedure);

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

Line 5526: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

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);

Line 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

Line 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;

Line 5537: p_msg_level=>fnd_log.level_procedure);

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

Line 5551: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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);

Line 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,

Line 5557: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 5560: p_msg_level=>fnd_log.level_procedure);

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:

Line 5570: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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);

Line 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,

Line 5576: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 5579: p_msg_level=>fnd_log.level_procedure);

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:

Line 5593: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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);

Line 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,

Line 5599: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 5602: p_msg_level=>fnd_log.level_procedure);

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:

Line 5695: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 5698: p_msg_level=>fnd_log.level_procedure);

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

Line 5739: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

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);

Line 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

Line 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;

Line 5750: p_msg_level=>fnd_log.level_procedure);

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

Line 5764: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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);

Line 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,

Line 5770: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 5773: p_msg_level=>fnd_log.level_procedure);

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:

Line 5783: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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);

Line 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,

Line 5789: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 5792: p_msg_level=>fnd_log.level_procedure);

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:

Line 5806: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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);

Line 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,

Line 5812: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 5815: p_msg_level=>fnd_log.level_procedure);

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:

Line 5908: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 5911: p_msg_level=>fnd_log.level_procedure);

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

Line 5952: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

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);

Line 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

Line 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;

Line 5963: p_msg_level=>fnd_log.level_procedure);

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

Line 5977: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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);

Line 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,

Line 5983: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 5986: p_msg_level=>fnd_log.level_procedure);

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:

Line 5996: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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);

Line 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,

Line 6002: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 6005: p_msg_level=>fnd_log.level_procedure);

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:

Line 6019: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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);

Line 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,

Line 6025: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;

Line 6028: p_msg_level=>fnd_log.level_procedure);

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: