eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_CONTACT_POINT_BO_PUB dependencies on HZ_UTILITY_V2PUB

Line 1129: px_contact_point_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

1125: px_contact_point_rec.primary_by_purpose := p_phone_obj.primary_by_purpose;
1126: IF(p_create_or_update = 'C') THEN
1127: px_contact_point_rec.orig_system := p_cp_os;
1128: px_contact_point_rec.orig_system_reference := p_cp_osr;
1129: px_contact_point_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
1130: END IF;
1131: px_contact_point_rec.actual_content_source := p_phone_obj.actual_content_source;
1132: px_phone_rec.phone_calling_calendar := p_phone_obj.phone_calling_calendar;
1133: px_phone_rec.last_contact_dt_time := p_phone_obj.last_contact_dt_time;

Line 1221: px_contact_point_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

1217: px_contact_point_rec.primary_by_purpose := p_telex_obj.primary_by_purpose;
1218: IF(p_create_or_update = 'C') THEN
1219: px_contact_point_rec.orig_system := p_cp_os;
1220: px_contact_point_rec.orig_system_reference := p_cp_osr;
1221: px_contact_point_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
1222: END IF;
1223: px_contact_point_rec.actual_content_source := p_telex_obj.actual_content_source;
1224: px_telex_rec.telex_number := p_telex_obj.telex_number;
1225: END assign_telex_rec;

Line 1305: px_contact_point_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

1301: px_contact_point_rec.primary_by_purpose := p_email_obj.primary_by_purpose;
1302: IF(p_create_or_update = 'C') THEN
1303: px_contact_point_rec.orig_system := p_cp_os;
1304: px_contact_point_rec.orig_system_reference := p_cp_osr;
1305: px_contact_point_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
1306: END IF;
1307: px_contact_point_rec.actual_content_source := p_email_obj.actual_content_source;
1308: px_email_rec.email_format := p_email_obj.email_format;
1309: px_email_rec.email_address := p_email_obj.email_address;

Line 1390: px_contact_point_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

1386: px_contact_point_rec.primary_by_purpose := p_web_obj.primary_by_purpose;
1387: IF(p_create_or_update = 'C') THEN
1388: px_contact_point_rec.orig_system := p_cp_os;
1389: px_contact_point_rec.orig_system_reference := p_cp_osr;
1390: px_contact_point_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
1391: END IF;
1392: px_contact_point_rec.actual_content_source := p_web_obj.actual_content_source;
1393: px_web_rec.web_type := p_web_obj.web_type;
1394: px_web_rec.url := p_web_obj.url;

Line 1475: px_contact_point_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

1471: px_contact_point_rec.primary_by_purpose := p_edi_obj.primary_by_purpose;
1472: IF(p_create_or_update = 'C') THEN
1473: px_contact_point_rec.orig_system := p_cp_os;
1474: px_contact_point_rec.orig_system_reference := p_cp_osr;
1475: px_contact_point_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
1476: END IF;
1477: px_contact_point_rec.actual_content_source := p_edi_obj.actual_content_source;
1478: px_edi_rec.edi_transaction_handling := p_edi_obj.edi_transaction_handling;
1479: px_edi_rec.edi_id_number := p_edi_obj.edi_id_number;

Line 1566: px_contact_point_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

1562: px_contact_point_rec.primary_by_purpose := p_eft_obj.primary_by_purpose;
1563: IF(p_create_or_update = 'C') THEN
1564: px_contact_point_rec.orig_system := p_cp_os;
1565: px_contact_point_rec.orig_system_reference := p_cp_osr;
1566: px_contact_point_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
1567: END IF;
1568: px_contact_point_rec.actual_content_source := p_eft_obj.actual_content_source;
1569: px_eft_rec.eft_transmission_program_id := p_eft_obj.eft_transmission_program_id;
1570: px_eft_rec.eft_printing_program_id := p_eft_obj.eft_printing_program_id;

Line 1653: px_contact_point_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

1649: px_contact_point_rec.primary_by_purpose := p_sms_obj.primary_by_purpose;
1650: IF(p_create_or_update = 'C') THEN
1651: px_contact_point_rec.orig_system := p_cp_os;
1652: px_contact_point_rec.orig_system_reference := p_cp_osr;
1653: px_contact_point_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
1654: END IF;
1655: px_contact_point_rec.actual_content_source := p_sms_obj.actual_content_source;
1656: px_sms_rec.phone_calling_calendar := p_sms_obj.phone_calling_calendar;
1657: px_sms_rec.last_contact_dt_time := p_sms_obj.last_contact_dt_time;

Line 1726: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';

1722: FND_MSG_PUB.initialize;
1723: END IF;
1724:
1725: -- initialize Global variable to indicate the caller of V2API is from BO API
1726: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
1727: IF(p_created_by_module IS NULL) THEN
1728: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
1729: ELSE
1730: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

Line 1728: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';

1724:
1725: -- initialize Global variable to indicate the caller of V2API is from BO API
1726: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
1727: IF(p_created_by_module IS NULL) THEN
1728: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
1729: ELSE
1730: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
1731: END IF;
1732:

Line 1730: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

1726: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
1727: IF(p_created_by_module IS NULL) THEN
1728: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
1729: ELSE
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

Line 1735: hz_utility_v2pub.debug(p_message=>'do_create_contact_point(+)',

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;
1739:

Line 1993: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

1989: RAISE fnd_api.g_exc_error;
1990: END IF;
1991:
1992: -- reset Global variable
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

Line 1994: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

1990: END IF;
1991:
1992: -- reset Global variable
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,

Line 1998: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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);
2002: END IF;

Line 2004: hz_utility_v2pub.debug(p_message=>'do_create_contact_point(-)',

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;
2008:

Line 2014: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

2010: WHEN fnd_api.g_exc_error THEN
2011: ROLLBACK TO do_create_contact_point_pub;
2012:
2013: -- reset Global variable
2014: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2015: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2016:
2017: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2018: FND_MESSAGE.SET_TOKEN('OBJECT', p_cp_type);

Line 2015: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

2011: ROLLBACK TO do_create_contact_point_pub;
2012:
2013: -- reset Global variable
2014: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2015: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2016:
2017: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2018: FND_MESSAGE.SET_TOKEN('OBJECT', p_cp_type);
2019: FND_MSG_PUB.ADD;

Line 2029: hz_utility_v2pub.debug_return_messages(p_msg_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);
2033: END IF;

Line 2035: hz_utility_v2pub.debug(p_message=>'do_create_contact_point (-)',

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;
2039:

Line 2044: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

2040: WHEN fnd_api.g_exc_unexpected_error THEN
2041: ROLLBACK TO do_create_contact_point_pub;
2042:
2043: -- reset Global variable
2044: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2045: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2046:
2047: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2048: FND_MESSAGE.SET_TOKEN('OBJECT', p_cp_type);

Line 2045: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

2041: ROLLBACK TO do_create_contact_point_pub;
2042:
2043: -- reset Global variable
2044: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2045: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2046:
2047: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2048: FND_MESSAGE.SET_TOKEN('OBJECT', p_cp_type);
2049: FND_MSG_PUB.ADD;

Line 2059: hz_utility_v2pub.debug_return_messages(p_msg_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);
2063: END IF;

Line 2065: hz_utility_v2pub.debug(p_message=>'do_create_contact_point (-)',

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;
2069:

Line 2074: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

2070: WHEN OTHERS THEN
2071: ROLLBACK TO do_create_contact_point_pub;
2072:
2073: -- reset Global variable
2074: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2075: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2076:
2077: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2078: FND_MESSAGE.SET_TOKEN('OBJECT', p_cp_type);

Line 2075: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

2071: ROLLBACK TO do_create_contact_point_pub;
2072:
2073: -- reset Global variable
2074: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2075: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2076:
2077: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2078: FND_MESSAGE.SET_TOKEN('OBJECT', p_cp_type);
2079: FND_MSG_PUB.ADD;

Line 2093: hz_utility_v2pub.debug_return_messages(p_msg_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);
2097: END IF;

Line 2099: hz_utility_v2pub.debug(p_message=>'do_create_contact_point (-)',

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;
2103: END do_create_contact_point;

Line 2807: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';

2803: FND_MSG_PUB.initialize;
2804: END IF;
2805:
2806: -- initialize Global variable
2807: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
2808: IF(p_created_by_module IS NULL) THEN
2809: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
2810: ELSE
2811: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

Line 2809: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';

2805:
2806: -- initialize Global variable
2807: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
2808: IF(p_created_by_module IS NULL) THEN
2809: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
2810: ELSE
2811: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
2812: END IF;
2813:

Line 2811: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

2807: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
2808: IF(p_created_by_module IS NULL) THEN
2809: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
2810: ELSE
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

Line 2816: hz_utility_v2pub.debug(p_message=>'do_update_contact_point (+)',

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;
2820:

Line 3048: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

3044: RAISE FND_API.G_EXC_ERROR;
3045: END IF;
3046:
3047: -- reset Global variable
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

Line 3049: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

3045: END IF;
3046:
3047: -- reset Global variable
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,

Line 3053: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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);
3057: END IF;

Line 3059: hz_utility_v2pub.debug(p_message=>'update_logical_cp(-)',

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;
3063:

Line 3069: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

3065: WHEN fnd_api.g_exc_error THEN
3066: ROLLBACK TO do_update_contact_point_pub;
3067:
3068: -- reset Global variable
3069: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
3070: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
3071:
3072: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
3073: FND_MESSAGE.SET_TOKEN('OBJECT', p_cp_type);

Line 3070: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

3066: ROLLBACK TO do_update_contact_point_pub;
3067:
3068: -- reset Global variable
3069: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
3070: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
3071:
3072: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
3073: FND_MESSAGE.SET_TOKEN('OBJECT', p_cp_type);
3074: FND_MSG_PUB.ADD;

Line 3084: hz_utility_v2pub.debug_return_messages(p_msg_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);
3088: END IF;

Line 3090: hz_utility_v2pub.debug(p_message=>'do_update_contact_point (-)',

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;
3094:

Line 3099: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

3095: WHEN fnd_api.g_exc_unexpected_error THEN
3096: ROLLBACK TO do_update_contact_point_pub;
3097:
3098: -- reset Global variable
3099: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
3100: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
3101:
3102: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
3103: FND_MESSAGE.SET_TOKEN('OBJECT', p_cp_type);

Line 3100: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

3096: ROLLBACK TO do_update_contact_point_pub;
3097:
3098: -- reset Global variable
3099: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
3100: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
3101:
3102: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
3103: FND_MESSAGE.SET_TOKEN('OBJECT', p_cp_type);
3104: FND_MSG_PUB.ADD;

Line 3114: hz_utility_v2pub.debug_return_messages(p_msg_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);
3118: END IF;

Line 3120: hz_utility_v2pub.debug(p_message=>'do_update_contact_point (-)',

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;
3124:

Line 3129: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

3125: WHEN OTHERS THEN
3126: ROLLBACK TO do_update_contact_point_pub;
3127:
3128: -- reset Global variable
3129: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
3130: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
3131:
3132: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
3133: FND_MESSAGE.SET_TOKEN('OBJECT', p_cp_type);

Line 3130: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

3126: ROLLBACK TO do_update_contact_point_pub;
3127:
3128: -- reset Global variable
3129: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
3130: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
3131:
3132: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
3133: FND_MESSAGE.SET_TOKEN('OBJECT', p_cp_type);
3134: FND_MSG_PUB.ADD;

Line 3148: hz_utility_v2pub.debug_return_messages(p_msg_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);
3152: END IF;

Line 3154: hz_utility_v2pub.debug(p_message=>'do_update_contact_point (-)',

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;
3158: END do_update_contact_point;

Line 4000: hz_utility_v2pub.debug(p_message=>'do_save_contact_point(+)',

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;
4004:

Line 4006: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';

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';
4007: IF(p_created_by_module IS NULL) THEN
4008: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
4009: ELSE
4010: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

Line 4008: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';

4004:
4005: -- initialize Global variable
4006: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
4007: IF(p_created_by_module IS NULL) THEN
4008: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
4009: ELSE
4010: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
4011: END IF;
4012:

Line 4010: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

4006: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
4007: IF(p_created_by_module IS NULL) THEN
4008: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
4009: ELSE
4010: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
4011: END IF;
4012:
4013: -- get contact point id and os+osr
4014: x_cp_id := p_cp_id;

Line 4431: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

4427: RAISE FND_API.G_EXC_ERROR;
4428: END IF;
4429:
4430: -- reset Global variable
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

Line 4432: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

4428: END IF;
4429:
4430: -- reset Global variable
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,

Line 4436: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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);
4440: END IF;

Line 4442: hz_utility_v2pub.debug(p_message=>'do_save_contact_point(-)',

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;
4446:

Line 4450: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

4446:
4447: EXCEPTION
4448: WHEN fnd_api.g_exc_error THEN
4449: -- reset Global variable
4450: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
4451: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
4452:
4453: x_return_status := fnd_api.g_ret_sts_error;
4454:

Line 4451: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

4447: EXCEPTION
4448: WHEN fnd_api.g_exc_error THEN
4449: -- reset Global variable
4450: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
4451: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
4452:
4453: x_return_status := fnd_api.g_ret_sts_error;
4454:
4455: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 4461: hz_utility_v2pub.debug_return_messages(p_msg_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);
4465: END IF;

Line 4467: hz_utility_v2pub.debug(p_message=>'do_save_contact_point(-)',

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;
4471:

Line 4474: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

4470: END IF;
4471:
4472: WHEN fnd_api.g_exc_unexpected_error THEN
4473: -- reset Global variable
4474: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
4475: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
4476:
4477: x_return_status := fnd_api.g_ret_sts_unexp_error;
4478:

Line 4475: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

4471:
4472: WHEN fnd_api.g_exc_unexpected_error THEN
4473: -- reset Global variable
4474: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
4475: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
4476:
4477: x_return_status := fnd_api.g_ret_sts_unexp_error;
4478:
4479: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 4485: hz_utility_v2pub.debug_return_messages(p_msg_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);
4489: END IF;

Line 4491: hz_utility_v2pub.debug(p_message=>'do_save_contact_point(-)',

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;
4495: WHEN OTHERS THEN

Line 4497: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

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;
4498: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
4499:
4500: x_return_status := fnd_api.g_ret_sts_unexp_error;
4501:

Line 4498: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

4494: END IF;
4495: WHEN OTHERS THEN
4496: -- reset Global variable
4497: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
4498: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
4499:
4500: x_return_status := fnd_api.g_ret_sts_unexp_error;
4501:
4502: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

Line 4512: hz_utility_v2pub.debug_return_messages(p_msg_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);
4516: END IF;

Line 4518: hz_utility_v2pub.debug(p_message=>'do_save_contact_point(-)',

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;
4522: END do_save_contact_point;

Line 4632: hz_utility_v2pub.debug(p_message=>'hz_phone_bo_pub.get_phone_bo(+)',

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;
4636:

Line 4676: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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);
4680: END IF;

Line 4684: hz_utility_v2pub.debug(p_message=>'hz_phone_bo_pub.get_phone_bo (-)',

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;
4688:

Line 4701: hz_utility_v2pub.debug_return_messages(p_msg_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);
4705: END IF;

Line 4707: hz_utility_v2pub.debug(p_message=>'hz_phone_bo_pub.get_phone_bo (-)',

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;
4711: WHEN fnd_api.g_exc_unexpected_error THEN

Line 4720: hz_utility_v2pub.debug_return_messages(p_msg_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);
4724: END IF;

Line 4726: hz_utility_v2pub.debug(p_message=>'hz_phone_bo_pub.get_phone_bo (-)',

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;
4730: WHEN OTHERS THEN

Line 4743: hz_utility_v2pub.debug_return_messages(p_msg_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);
4747: END IF;

Line 4749: hz_utility_v2pub.debug(p_message=>'hz_phone_bo_pub.get_phone_bo (-)',

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;
4753:

Line 4845: hz_utility_v2pub.debug(p_message=>'hz_telex_bo_pub.get_telex_bo(+)',

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;
4849:

Line 4889: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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);
4893: END IF;

Line 4897: hz_utility_v2pub.debug(p_message=>'hz_telex_bo_pub.get_telex_bo (-)',

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;
4901:

Line 4914: hz_utility_v2pub.debug_return_messages(p_msg_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);
4918: END IF;

Line 4920: hz_utility_v2pub.debug(p_message=>'hz_telex_bo_pub.get_telex_bo (-)',

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;
4924: WHEN fnd_api.g_exc_unexpected_error THEN

Line 4933: hz_utility_v2pub.debug_return_messages(p_msg_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);
4937: END IF;

Line 4939: hz_utility_v2pub.debug(p_message=>'hz_telex_bo_pub.get_telex_bo (-)',

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;
4943: WHEN OTHERS THEN

Line 4956: hz_utility_v2pub.debug_return_messages(p_msg_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);
4960: END IF;

Line 4962: hz_utility_v2pub.debug(p_message=>'hz_telex_bo_pub.get_telex_bo (-)',

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;
4966:

Line 5058: hz_utility_v2pub.debug(p_message=>'hz_email_bo_pub.get_email_bo(+)',

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;
5062:

Line 5102: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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);
5106: END IF;

Line 5110: hz_utility_v2pub.debug(p_message=>'hz_email_bo_pub.get_email_bo (-)',

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;
5114:

Line 5127: hz_utility_v2pub.debug_return_messages(p_msg_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);
5131: END IF;

Line 5133: hz_utility_v2pub.debug(p_message=>'hz_email_bo_pub.get_email_bo (-)',

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;
5137: WHEN fnd_api.g_exc_unexpected_error THEN

Line 5146: hz_utility_v2pub.debug_return_messages(p_msg_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);
5150: END IF;

Line 5152: hz_utility_v2pub.debug(p_message=>'hz_email_bo_pub.get_email_bo (-)',

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;
5156: WHEN OTHERS THEN

Line 5169: hz_utility_v2pub.debug_return_messages(p_msg_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);
5173: END IF;

Line 5175: hz_utility_v2pub.debug(p_message=>'hz_email_bo_pub.get_email_bo (-)',

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;
5179:

Line 5271: hz_utility_v2pub.debug(p_message=>'hz_web_bo_pub.get_web_bo(+)',

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;
5275:

Line 5315: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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);
5319: END IF;

Line 5323: hz_utility_v2pub.debug(p_message=>'hz_web_bo_pub.get_web_bo (-)',

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;
5327:

Line 5340: hz_utility_v2pub.debug_return_messages(p_msg_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);
5344: END IF;

Line 5346: hz_utility_v2pub.debug(p_message=>'hz_web_bo_pub.get_web_bo (-)',

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;
5350: WHEN fnd_api.g_exc_unexpected_error THEN

Line 5359: hz_utility_v2pub.debug_return_messages(p_msg_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);
5363: END IF;

Line 5365: hz_utility_v2pub.debug(p_message=>'hz_web_bo_pub.get_web_bo (-)',

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;
5369: WHEN OTHERS THEN

Line 5382: hz_utility_v2pub.debug_return_messages(p_msg_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);
5386: END IF;

Line 5388: hz_utility_v2pub.debug(p_message=>'hz_web_bo_pub.get_web_bo (-)',

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;
5392:

Line 5483: hz_utility_v2pub.debug(p_message=>'hz_edi_bo_pub.get_edi_bo(+)',

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;
5487:

Line 5527: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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);
5531: END IF;

Line 5535: hz_utility_v2pub.debug(p_message=>'hz_edi_bo_pub.get_edi_bo (-)',

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;
5539:

Line 5552: hz_utility_v2pub.debug_return_messages(p_msg_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);
5556: END IF;

Line 5558: hz_utility_v2pub.debug(p_message=>'hz_edi_bo_pub.get_edi_bo (-)',

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;
5562: WHEN fnd_api.g_exc_unexpected_error THEN

Line 5571: hz_utility_v2pub.debug_return_messages(p_msg_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);
5575: END IF;

Line 5577: hz_utility_v2pub.debug(p_message=>'hz_edi_bo_pub.get_edi_bo (-)',

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;
5581: WHEN OTHERS THEN

Line 5594: hz_utility_v2pub.debug_return_messages(p_msg_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);
5598: END IF;

Line 5600: hz_utility_v2pub.debug(p_message=>'hz_edi_bo_pub.get_edi_bo (-)',

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;
5604:

Line 5696: hz_utility_v2pub.debug(p_message=>'hz_eft_bo_pub.get_eft_bo(+)',

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;
5700:

Line 5740: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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);
5744: END IF;

Line 5748: hz_utility_v2pub.debug(p_message=>'hz_eft_bo_pub.get_eft_bo (-)',

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;
5752:

Line 5765: hz_utility_v2pub.debug_return_messages(p_msg_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);
5769: END IF;

Line 5771: hz_utility_v2pub.debug(p_message=>'hz_eft_bo_pub.get_eft_bo (-)',

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;
5775: WHEN fnd_api.g_exc_unexpected_error THEN

Line 5784: hz_utility_v2pub.debug_return_messages(p_msg_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);
5788: END IF;

Line 5790: hz_utility_v2pub.debug(p_message=>'hz_eft_bo_pub.get_eft_bo (-)',

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;
5794: WHEN OTHERS THEN

Line 5807: hz_utility_v2pub.debug_return_messages(p_msg_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);
5811: END IF;

Line 5813: hz_utility_v2pub.debug(p_message=>'hz_eft_bo_pub.get_eft_bo (-)',

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;
5817:

Line 5909: hz_utility_v2pub.debug(p_message=>'hz_sms_bo_pub.get_sms_bo(+)',

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;
5913:

Line 5953: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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);
5957: END IF;

Line 5961: hz_utility_v2pub.debug(p_message=>'hz_sms_bo_pub.get_sms_bo (-)',

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;
5965:

Line 5978: hz_utility_v2pub.debug_return_messages(p_msg_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);
5982: END IF;

Line 5984: hz_utility_v2pub.debug(p_message=>'hz_sms_bo_pub.get_sms_bo (-)',

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;
5988: WHEN fnd_api.g_exc_unexpected_error THEN

Line 5997: hz_utility_v2pub.debug_return_messages(p_msg_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);
6001: END IF;

Line 6003: hz_utility_v2pub.debug(p_message=>'hz_sms_bo_pub.get_sms_bo (-)',

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;
6007: WHEN OTHERS THEN

Line 6020: hz_utility_v2pub.debug_return_messages(p_msg_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);
6024: END IF;

Line 6026: hz_utility_v2pub.debug(p_message=>'hz_sms_bo_pub.get_sms_bo (-)',

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;
6030: