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.IBE_PARTY_V2PVT dependencies on HZ_CONTACT_PREFERENCE_V2PUB

Line 1656: | - HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference if no row exists

1652: |
1653: |
1654: | REFERENCED APIS
1655: | This API calls the following APIs
1656: | - HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference if no row exists
1657: | - HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference if row exists
1658: +=============================================================================*/
1659: PROCEDURE Update_Contact_Preference(
1660: p_party_id IN NUMBER,

Line 1657: | - HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference if row exists

1653: |
1654: | REFERENCED APIS
1655: | This API calls the following APIs
1656: | - HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference if no row exists
1657: | - HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference if row exists
1658: +=============================================================================*/
1659: PROCEDURE Update_Contact_Preference(
1660: p_party_id IN NUMBER,
1661: p_preference IN VARCHAR2,

Line 1670: l_contact_preference_rec hz_contact_preference_v2pub.contact_preference_rec_type;

1666: x_msg_data OUT NOCOPY VARCHAR2
1667:
1668: )
1669: IS
1670: l_contact_preference_rec hz_contact_preference_v2pub.contact_preference_rec_type;
1671: l_contact_preference_rec2 hz_contact_preference_v2pub.contact_preference_rec_type;
1672: l_contact_preference_id NUMBER;
1673: l_object_version_number NUMBER;
1674: l_id NUMBER;

Line 1671: l_contact_preference_rec2 hz_contact_preference_v2pub.contact_preference_rec_type;

1667:
1668: )
1669: IS
1670: l_contact_preference_rec hz_contact_preference_v2pub.contact_preference_rec_type;
1671: l_contact_preference_rec2 hz_contact_preference_v2pub.contact_preference_rec_type;
1672: l_contact_preference_id NUMBER;
1673: l_object_version_number NUMBER;
1674: l_id NUMBER;
1675:

Line 1700: IBE_UTIL.debug('Call HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference API');

1696: if (p_object_version_number is not null) then
1697: l_object_version_number := p_object_version_number;
1698: end if;
1699: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1700: IBE_UTIL.debug('Call HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference API');
1701: END IF;
1702: HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference(
1703: FND_API.G_FALSE,
1704: l_contact_preference_rec,

Line 1702: HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference(

1698: end if;
1699: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1700: IBE_UTIL.debug('Call HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference API');
1701: END IF;
1702: HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference(
1703: FND_API.G_FALSE,
1704: l_contact_preference_rec,
1705: l_object_version_number,
1706: x_return_status,

Line 1711: IBE_UTIL.debug('After Call HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference API');

1707: x_msg_count,
1708: x_msg_data
1709: );
1710: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1711: IBE_UTIL.debug('After Call HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference API');
1712: END IF;
1713: --create row when no record found
1714: EXCEPTION WHEN NO_DATA_FOUND THEN
1715: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 1728: IBE_UTIL.debug('Call HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference API');

1724: l_contact_preference_rec2.status := 'A';
1725: l_contact_preference_rec2.created_by_module := p_created_by_module;
1726:
1727: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1728: IBE_UTIL.debug('Call HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference API');
1729: END IF;
1730: HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference(
1731: FND_API.G_FALSE,
1732: l_contact_preference_rec2,

Line 1730: HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference(

1726:
1727: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1728: IBE_UTIL.debug('Call HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference API');
1729: END IF;
1730: HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference(
1731: FND_API.G_FALSE,
1732: l_contact_preference_rec2,
1733: l_contact_preference_id,
1734: x_return_status,

Line 1739: IBE_UTIL.debug('After call to HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference API');

1735: x_msg_count,
1736: x_msg_data
1737: );
1738: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1739: IBE_UTIL.debug('After call to HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference API');
1740: END IF;
1741: END;
1742: --end set/create contact preferences
1743:

Line 2245: l_cntct_pref_rec hz_contact_preference_v2pub.contact_preference_rec_type;

2241: l_account_rec hz_cust_account_v2pub.cust_account_rec_type;
2242: l_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
2243: l_party_site_rec hz_party_site_v2pub.party_site_rec_type;
2244: l_custacct_role_rec hz_cust_account_role_v2pub.cust_account_role_rec_type;
2245: l_cntct_pref_rec hz_contact_preference_v2pub.contact_preference_rec_type;
2246:
2247: --Local variables
2248: l_party_type varchar2(30);
2249: l_party_status varchar2(1);

Line 2492: hz_contact_preference_v2pub.update_contact_preference

2488: IBE_UTIL.debug('Update Preference Id'||rec_cntct_pref.contact_preference_id);
2489: END IF;
2490: l_cntct_pref_rec.contact_preference_id := rec_cntct_pref.contact_preference_id;
2491: l_cntct_pref_rec.status := p_party_status;
2492: hz_contact_preference_v2pub.update_contact_preference
2493: (p_contact_preference_rec => l_cntct_pref_rec,
2494: p_object_version_number => rec_cntct_pref.object_version_number,
2495: x_return_status => x_return_status,
2496: x_msg_count => x_msg_count,

Line 2706: | HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference()

2702: | HZ_LOCATION_V2PUB.create_location()
2703: | HZ_LOCATION_V2PUB.update_location()
2704: | HZ_PARTY_SITE_V2PUB.create_party_site()
2705: | HZ_PARTY_CONTACT_V2PUB.create_org_contact()
2706: | HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference()
2707: | HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference()
2708: | HZ_CONTACT_POINT_V2PUB.create_email_contact_point (
2709: | HZ_CONTACT_POINT_V2PUB.update_email_contact_point (
2710: | HZ_CONTACT_POINT_V2PUB.create_phone_contact_point (

Line 2707: | HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference()

2703: | HZ_LOCATION_V2PUB.update_location()
2704: | HZ_PARTY_SITE_V2PUB.create_party_site()
2705: | HZ_PARTY_CONTACT_V2PUB.create_org_contact()
2706: | HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference()
2707: | HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference()
2708: | HZ_CONTACT_POINT_V2PUB.create_email_contact_point (
2709: | HZ_CONTACT_POINT_V2PUB.update_email_contact_point (
2710: | HZ_CONTACT_POINT_V2PUB.create_phone_contact_point (
2711: | HZ_CONTACT_POINT_V2PUB.update_phone_contact_point (

Line 2729: p_contact_pref_rec IN HZ_CONTACT_PREFERENCE_V2PUB.contact_preference_rec_type,

2725: p_homeph_object_version_number IN NUMBER,
2726: p_fax_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
2727: p_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
2728: p_fax_object_version_number IN NUMBER,
2729: p_contact_pref_rec IN HZ_CONTACT_PREFERENCE_V2PUB.contact_preference_rec_type,
2730: p_cntct_pref_object_ver_num IN NUMBER,
2731: p_organization_rec IN HZ_PARTY_V2PUB.organization_rec_type,
2732: p_org_object_version_number IN NUMBER,
2733: p_location_rec IN HZ_LOCATION_V2PUB.location_rec_type,

Line 2780: l_contact_pref_rec HZ_CONTACT_PREFERENCE_V2PUB.contact_preference_rec_type := p_contact_pref_rec;

2776: l_party_site_id NUMBER;
2777: l_party_site_number HZ_PARTY_SITES.PARTY_SITE_NUMBER%TYPE;
2778:
2779: l_party_site_rec HZ_PARTY_SITE_V2PUB.party_site_rec_type;
2780: l_contact_pref_rec HZ_CONTACT_PREFERENCE_V2PUB.contact_preference_rec_type := p_contact_pref_rec;
2781: l_person_rec HZ_PARTY_V2PUB.person_rec_type := p_person_rec;
2782: l_organization_rec HZ_PARTY_V2PUB.organization_rec_type := p_organization_rec;
2783:
2784: l_email_contact_point_id NUMBER;

Line 3150: IBE_UTIL.debug('Call HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference API');

3146: -- Create contact preference
3147: IF ( l_contact_pref_rec.contact_preference_id = FND_API.G_MISS_NUM or l_contact_pref_rec.contact_preference_id is NULL AND
3148: (l_contact_pref_rec.preference_code is not null AND l_contact_pref_rec.preference_code <> FND_API.G_MISS_CHAR)) THEN
3149: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3150: IBE_UTIL.debug('Call HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference API');
3151: END IF;
3152: l_contact_pref_rec.contact_type := 'ALL';
3153: l_contact_pref_rec.requested_by := 'INTERNAL';
3154: l_contact_pref_rec.status := 'A';

Line 3158: HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference(

3154: l_contact_pref_rec.status := 'A';
3155: l_contact_pref_rec.created_by_module := p_created_by_module;
3156:
3157:
3158: HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference(
3159:
3160: p_contact_preference_rec => l_contact_pref_rec,
3161: x_contact_preference_id => l_contact_preference_id,
3162: x_return_status => x_return_status,

Line 3166: IBE_UTIL.debug('After Call to HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference API');

3162: x_return_status => x_return_status,
3163: x_msg_count => x_msg_count,
3164: x_msg_data => x_msg_data);
3165: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3166: IBE_UTIL.debug('After Call to HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference API');
3167: END IF;
3168: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3169: IBE_UTIL.debug('After call to HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference - x_return_status : '|| x_return_status);
3170: IBE_UTIL.debug('After call to HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference - x_msg_count : '|| x_msg_count);

Line 3169: IBE_UTIL.debug('After call to HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference - x_return_status : '|| x_return_status);

3165: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3166: IBE_UTIL.debug('After Call to HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference API');
3167: END IF;
3168: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3169: IBE_UTIL.debug('After call to HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference - x_return_status : '|| x_return_status);
3170: IBE_UTIL.debug('After call to HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference - x_msg_count : '|| x_msg_count);
3171: IBE_UTIL.debug('After call to HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference - x_msg_data :' || x_msg_data);
3172: END IF;
3173: ELSIF ( l_cntct_pref_object_ver_num <> FND_API.G_MISS_NUM ) THEN

Line 3170: IBE_UTIL.debug('After call to HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference - x_msg_count : '|| x_msg_count);

3166: IBE_UTIL.debug('After Call to HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference API');
3167: END IF;
3168: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3169: IBE_UTIL.debug('After call to HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference - x_return_status : '|| x_return_status);
3170: IBE_UTIL.debug('After call to HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference - x_msg_count : '|| x_msg_count);
3171: IBE_UTIL.debug('After call to HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference - x_msg_data :' || x_msg_data);
3172: END IF;
3173: ELSIF ( l_cntct_pref_object_ver_num <> FND_API.G_MISS_NUM ) THEN
3174: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 3171: IBE_UTIL.debug('After call to HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference - x_msg_data :' || x_msg_data);

3167: END IF;
3168: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3169: IBE_UTIL.debug('After call to HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference - x_return_status : '|| x_return_status);
3170: IBE_UTIL.debug('After call to HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference - x_msg_count : '|| x_msg_count);
3171: IBE_UTIL.debug('After call to HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference - x_msg_data :' || x_msg_data);
3172: END IF;
3173: ELSIF ( l_cntct_pref_object_ver_num <> FND_API.G_MISS_NUM ) THEN
3174: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3175: IBE_UTIL.debug('Call HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference API');

Line 3175: IBE_UTIL.debug('Call HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference API');

3171: IBE_UTIL.debug('After call to HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference - x_msg_data :' || x_msg_data);
3172: END IF;
3173: ELSIF ( l_cntct_pref_object_ver_num <> FND_API.G_MISS_NUM ) THEN
3174: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3175: IBE_UTIL.debug('Call HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference API');
3176: END IF;
3177:
3178: HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference(
3179: p_contact_preference_rec => l_contact_pref_rec,

Line 3178: HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference(

3174: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3175: IBE_UTIL.debug('Call HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference API');
3176: END IF;
3177:
3178: HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference(
3179: p_contact_preference_rec => l_contact_pref_rec,
3180: p_object_version_number => l_cntct_pref_object_ver_num,
3181: x_return_status => x_return_status,
3182: x_msg_count => x_msg_count,

Line 3185: IBE_UTIL.debug('After Call to HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference API');

3181: x_return_status => x_return_status,
3182: x_msg_count => x_msg_count,
3183: x_msg_data => x_msg_data);
3184: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3185: IBE_UTIL.debug('After Call to HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference API');
3186: END IF;
3187: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3188: IBE_UTIL.debug('After call to HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference - x_return_status : '|| x_return_status);
3189: IBE_UTIL.debug('After call to HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference - x_msg_count : '|| x_msg_count);

Line 3188: IBE_UTIL.debug('After call to HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference - x_return_status : '|| x_return_status);

3184: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3185: IBE_UTIL.debug('After Call to HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference API');
3186: END IF;
3187: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3188: IBE_UTIL.debug('After call to HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference - x_return_status : '|| x_return_status);
3189: IBE_UTIL.debug('After call to HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference - x_msg_count : '|| x_msg_count);
3190: IBE_UTIL.debug('After call to HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference - x_msg_data :' || x_msg_data);
3191: END IF;
3192: END IF;

Line 3189: IBE_UTIL.debug('After call to HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference - x_msg_count : '|| x_msg_count);

3185: IBE_UTIL.debug('After Call to HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference API');
3186: END IF;
3187: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3188: IBE_UTIL.debug('After call to HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference - x_return_status : '|| x_return_status);
3189: IBE_UTIL.debug('After call to HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference - x_msg_count : '|| x_msg_count);
3190: IBE_UTIL.debug('After call to HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference - x_msg_data :' || x_msg_data);
3191: END IF;
3192: END IF;
3193:

Line 3190: IBE_UTIL.debug('After call to HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference - x_msg_data :' || x_msg_data);

3186: END IF;
3187: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3188: IBE_UTIL.debug('After call to HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference - x_return_status : '|| x_return_status);
3189: IBE_UTIL.debug('After call to HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference - x_msg_count : '|| x_msg_count);
3190: IBE_UTIL.debug('After call to HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference - x_msg_data :' || x_msg_data);
3191: END IF;
3192: END IF;
3193:
3194: IF x_return_status <> FND_API.G_RET_STS_SUCCESS then