DBA Data[Home] [Help]

APPS.WSH_SUPPLIER_PARTY dependencies on HZ_CONTACT_POINT_V2PUB

Line 1440: -- call api HZ_CONTACT_POINT_V2PUB.Create_phone_Contact_Point to create phone

1436: -- API name : Create_hz_phone_contact
1437: -- Type : Public
1438: -- Pre-reqs : None.
1439: -- Procedure: API to create Hz Contact for phone. If phone number input is not null
1440: -- call api HZ_CONTACT_POINT_V2PUB.Create_phone_Contact_Point to create phone
1441: -- contact.
1442: -- Parameters :
1443: -- IN:
1444: -- P_phone IN Phone Number.

Line 1459: l_contact_points_rec_type hz_contact_point_v2pub.contact_point_rec_type;

1455: l_msg_count number;
1456: l_msg_data varchar2(2000);
1457: l_contact_point_id number;
1458:
1459: l_contact_points_rec_type hz_contact_point_v2pub.contact_point_rec_type;
1460: l_phone_rec_type hz_contact_point_v2pub.phone_rec_type;
1461:
1462: l_debug_on BOOLEAN;
1463: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Create_hz_phone_contact';

Line 1460: l_phone_rec_type hz_contact_point_v2pub.phone_rec_type;

1456: l_msg_data varchar2(2000);
1457: l_contact_point_id number;
1458:
1459: l_contact_points_rec_type hz_contact_point_v2pub.contact_point_rec_type;
1460: l_phone_rec_type hz_contact_point_v2pub.phone_rec_type;
1461:
1462: l_debug_on BOOLEAN;
1463: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Create_hz_phone_contact';
1464: l_num_warnings number;

Line 1496: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit HZ_CONTACT_POINT_V2PUB.Create_Contact_Point for PHONE'

1492: l_phone_rec_type.phone_line_type := 'GEN';
1493: l_contact_points_rec_type.primary_flag := 'N';
1494:
1495: IF l_debug_on THEN
1496: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit HZ_CONTACT_POINT_V2PUB.Create_Contact_Point for PHONE'
1497: ,WSH_DEBUG_SV.C_PROC_LEVEL);
1498: END IF;
1499: HZ_CONTACT_POINT_V2PUB.Create_phone_Contact_Point (
1500: p_init_msg_list => FND_API.G_FALSE,

Line 1499: HZ_CONTACT_POINT_V2PUB.Create_phone_Contact_Point (

1495: IF l_debug_on THEN
1496: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit HZ_CONTACT_POINT_V2PUB.Create_Contact_Point for PHONE'
1497: ,WSH_DEBUG_SV.C_PROC_LEVEL);
1498: END IF;
1499: HZ_CONTACT_POINT_V2PUB.Create_phone_Contact_Point (
1500: p_init_msg_list => FND_API.G_FALSE,
1501: p_contact_point_rec => l_contact_points_rec_type,
1502: p_phone_rec => l_phone_rec_type,
1503: x_contact_point_id => l_contact_point_id,

Line 1509: WSH_DEBUG_SV.log(l_module_name,'HZ_CONTACT_POINT_V2PUB.Create_phone_Contact_Point l_contact_point_id',l_contact_point_id);

1505: x_msg_count => l_msg_count,
1506: x_msg_data => l_msg_data);
1507:
1508: IF l_debug_on THEN
1509: WSH_DEBUG_SV.log(l_module_name,'HZ_CONTACT_POINT_V2PUB.Create_phone_Contact_Point l_contact_point_id',l_contact_point_id);
1510: WSH_DEBUG_SV.log(l_module_name,'l_contact_point_id',l_contact_point_id);
1511: END IF;
1512: wsh_util_core.api_post_call(
1513: p_return_status => l_return_status,

Line 1591: l_contact_points_rec_type hz_contact_point_v2pub.contact_point_rec_type;

1587: IS
1588:
1589: l_person_rec HZ_PARTY_V2PUB.person_rec_type;
1590: l_ocon_rec HZ_PARTY_CONTACT_V2PUB.ORG_CONTACT_REC_TYPE;
1591: l_contact_points_rec_type hz_contact_point_v2pub.contact_point_rec_type;
1592: l_email_rec_type hz_contact_point_v2pub.email_rec_type;
1593: l_phone_rec_type hz_contact_point_v2pub.phone_rec_type;
1594:
1595: l_return_status varchar2(100);

Line 1592: l_email_rec_type hz_contact_point_v2pub.email_rec_type;

1588:
1589: l_person_rec HZ_PARTY_V2PUB.person_rec_type;
1590: l_ocon_rec HZ_PARTY_CONTACT_V2PUB.ORG_CONTACT_REC_TYPE;
1591: l_contact_points_rec_type hz_contact_point_v2pub.contact_point_rec_type;
1592: l_email_rec_type hz_contact_point_v2pub.email_rec_type;
1593: l_phone_rec_type hz_contact_point_v2pub.phone_rec_type;
1594:
1595: l_return_status varchar2(100);
1596: l_msg_count number;

Line 1593: l_phone_rec_type hz_contact_point_v2pub.phone_rec_type;

1589: l_person_rec HZ_PARTY_V2PUB.person_rec_type;
1590: l_ocon_rec HZ_PARTY_CONTACT_V2PUB.ORG_CONTACT_REC_TYPE;
1591: l_contact_points_rec_type hz_contact_point_v2pub.contact_point_rec_type;
1592: l_email_rec_type hz_contact_point_v2pub.email_rec_type;
1593: l_phone_rec_type hz_contact_point_v2pub.phone_rec_type;
1594:
1595: l_return_status varchar2(100);
1596: l_msg_count number;
1597: l_msg_data varchar2(2000);

Line 1715: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program Unit HZ_CONTACT_POINT_V2PUB.Update_Contact_Point for Phone',WSH_DEBUG_SV.C_PROC_LEVEL);

1711: CLOSE Get_Cont_Point_Version ;
1712:
1713:
1714: IF l_debug_on THEN
1715: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program Unit HZ_CONTACT_POINT_V2PUB.Update_Contact_Point for Phone',WSH_DEBUG_SV.C_PROC_LEVEL);
1716: END IF;
1717:
1718: HZ_CONTACT_POINT_V2PUB.Update_Contact_Point(
1719: p_init_msg_list => FND_API.G_FALSE,

Line 1718: HZ_CONTACT_POINT_V2PUB.Update_Contact_Point(

1714: IF l_debug_on THEN
1715: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program Unit HZ_CONTACT_POINT_V2PUB.Update_Contact_Point for Phone',WSH_DEBUG_SV.C_PROC_LEVEL);
1716: END IF;
1717:
1718: HZ_CONTACT_POINT_V2PUB.Update_Contact_Point(
1719: p_init_msg_list => FND_API.G_FALSE,
1720: p_contact_point_rec => l_contact_points_rec_type,
1721: p_phone_rec => l_phone_rec_type,
1722: p_object_version_number => l_cont_point_version,

Line 1728: WSH_DEBUG_SV.log(l_module_name,'HZ_CONTACT_POINT_V2PUB.Update_Contact_Point l_return_status',l_return_status);

1724: x_msg_count => l_msg_count,
1725: x_msg_data => l_msg_data );
1726:
1727: IF l_debug_on THEN
1728: WSH_DEBUG_SV.log(l_module_name,'HZ_CONTACT_POINT_V2PUB.Update_Contact_Point l_return_status',l_return_status);
1729: WSH_DEBUG_SV.log(l_module_name,'l_msg_count',l_msg_count);
1730: WSH_DEBUG_SV.log(l_module_name,'l_msg_data',l_msg_data);
1731: END IF;
1732: wsh_util_core.api_post_call(

Line 1755: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program Unit HZ_CONTACT_POINT_V2PUB.Update_Contact_Point',WSH_DEBUG_SV.

1751: CLOSE Get_Cont_Point_Version ;
1752:
1753:
1754: IF l_debug_on THEN
1755: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program Unit HZ_CONTACT_POINT_V2PUB.Update_Contact_Point',WSH_DEBUG_SV.
1756: C_PROC_LEVEL);
1757: END IF;
1758:
1759: HZ_CONTACT_POINT_V2PUB.Update_Contact_Point(

Line 1759: HZ_CONTACT_POINT_V2PUB.Update_Contact_Point(

1755: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program Unit HZ_CONTACT_POINT_V2PUB.Update_Contact_Point',WSH_DEBUG_SV.
1756: C_PROC_LEVEL);
1757: END IF;
1758:
1759: HZ_CONTACT_POINT_V2PUB.Update_Contact_Point(
1760: p_init_msg_list => FND_API.G_FALSE,
1761: p_contact_point_rec => l_contact_points_rec_type,
1762: p_email_rec => l_email_rec_type,
1763: p_object_version_number => l_cont_point_version,

Line 1769: WSH_DEBUG_SV.log(l_module_name,'HZ_CONTACT_POINT_V2PUB.Update_Contact_Point l_return_status',l_return_status);

1765: x_msg_count => l_msg_count,
1766: x_msg_data => l_msg_data );
1767:
1768: IF l_debug_on THEN
1769: WSH_DEBUG_SV.log(l_module_name,'HZ_CONTACT_POINT_V2PUB.Update_Contact_Point l_return_status',l_return_status);
1770: WSH_DEBUG_SV.log(l_module_name,'l_msg_count',l_msg_count);
1771: WSH_DEBUG_SV.log(l_module_name,'l_msg_data',l_msg_data);
1772: END IF;
1773:

Line 1883: l_contact_points_rec_type hz_contact_point_v2pub.contact_point_rec_type;

1879: l_person_party_id number;
1880:
1881: l_rel_rec_type HZ_RELATIONSHIP_V2PUB.RELATIONSHIP_REC_TYPE;
1882: l_ocon_rec HZ_PARTY_CONTACT_V2PUB.ORG_CONTACT_REC_TYPE;
1883: l_contact_points_rec_type hz_contact_point_v2pub.contact_point_rec_type;
1884: l_email_rec_type hz_contact_point_v2pub.email_rec_type;
1885: l_phone_rec_type hz_contact_point_v2pub.phone_rec_type;
1886:
1887: l_debug_on BOOLEAN;

Line 1884: l_email_rec_type hz_contact_point_v2pub.email_rec_type;

1880:
1881: l_rel_rec_type HZ_RELATIONSHIP_V2PUB.RELATIONSHIP_REC_TYPE;
1882: l_ocon_rec HZ_PARTY_CONTACT_V2PUB.ORG_CONTACT_REC_TYPE;
1883: l_contact_points_rec_type hz_contact_point_v2pub.contact_point_rec_type;
1884: l_email_rec_type hz_contact_point_v2pub.email_rec_type;
1885: l_phone_rec_type hz_contact_point_v2pub.phone_rec_type;
1886:
1887: l_debug_on BOOLEAN;
1888: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Create_HZ_contact';

Line 1885: l_phone_rec_type hz_contact_point_v2pub.phone_rec_type;

1881: l_rel_rec_type HZ_RELATIONSHIP_V2PUB.RELATIONSHIP_REC_TYPE;
1882: l_ocon_rec HZ_PARTY_CONTACT_V2PUB.ORG_CONTACT_REC_TYPE;
1883: l_contact_points_rec_type hz_contact_point_v2pub.contact_point_rec_type;
1884: l_email_rec_type hz_contact_point_v2pub.email_rec_type;
1885: l_phone_rec_type hz_contact_point_v2pub.phone_rec_type;
1886:
1887: l_debug_on BOOLEAN;
1888: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Create_HZ_contact';
1889: l_num_warnings number;

Line 1993: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit HZ_CONTACT_POINT_V2PUB.Create_Contact_Point for EMAIL',WSH_DEBUG_SV.C_PROC_LEVEL);

1989: l_contact_points_rec_type.contact_point_type := 'EMAIL';
1990: l_email_rec_type.email_address := p_email;
1991:
1992: IF l_debug_on THEN
1993: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit HZ_CONTACT_POINT_V2PUB.Create_Contact_Point for EMAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
1994: END IF;
1995: HZ_CONTACT_POINT_V2PUB.Create_email_Contact_Point (
1996: p_init_msg_list => FND_API.G_FALSE,
1997: p_contact_point_rec => l_contact_points_rec_type,

Line 1995: HZ_CONTACT_POINT_V2PUB.Create_email_Contact_Point (

1991:
1992: IF l_debug_on THEN
1993: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit HZ_CONTACT_POINT_V2PUB.Create_Contact_Point for EMAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
1994: END IF;
1995: HZ_CONTACT_POINT_V2PUB.Create_email_Contact_Point (
1996: p_init_msg_list => FND_API.G_FALSE,
1997: p_contact_point_rec => l_contact_points_rec_type,
1998: p_email_rec => l_email_rec_type,
1999: x_contact_point_id => l_contact_point_id,

Line 2005: WSH_DEBUG_SV.log(l_module_name,'HZ_CONTACT_POINT_V2PUB.Create_email_Contact_Point l_return_status',l_return_status);

2001: x_msg_count => l_msg_count,
2002: x_msg_data => l_msg_data);
2003:
2004: IF l_debug_on THEN
2005: WSH_DEBUG_SV.log(l_module_name,'HZ_CONTACT_POINT_V2PUB.Create_email_Contact_Point l_return_status',l_return_status);
2006: WSH_DEBUG_SV.log(l_module_name,'l_contact_point_id',l_contact_point_id);
2007: END IF;
2008: wsh_util_core.api_post_call(
2009: p_return_status => l_return_status,

Line 2096: l_contact_points_rec_type hz_contact_point_v2pub.contact_point_rec_type;

2092: IS
2093:
2094: l_person_rec HZ_PARTY_V2PUB.person_rec_type;
2095: l_ocon_rec HZ_PARTY_CONTACT_V2PUB.ORG_CONTACT_REC_TYPE;
2096: l_contact_points_rec_type hz_contact_point_v2pub.contact_point_rec_type;
2097: l_email_rec_type hz_contact_point_v2pub.email_rec_type;
2098: l_phone_rec_type hz_contact_point_v2pub.phone_rec_type;
2099:
2100: l_return_status varchar2(100);

Line 2097: l_email_rec_type hz_contact_point_v2pub.email_rec_type;

2093:
2094: l_person_rec HZ_PARTY_V2PUB.person_rec_type;
2095: l_ocon_rec HZ_PARTY_CONTACT_V2PUB.ORG_CONTACT_REC_TYPE;
2096: l_contact_points_rec_type hz_contact_point_v2pub.contact_point_rec_type;
2097: l_email_rec_type hz_contact_point_v2pub.email_rec_type;
2098: l_phone_rec_type hz_contact_point_v2pub.phone_rec_type;
2099:
2100: l_return_status varchar2(100);
2101: l_msg_count number;

Line 2098: l_phone_rec_type hz_contact_point_v2pub.phone_rec_type;

2094: l_person_rec HZ_PARTY_V2PUB.person_rec_type;
2095: l_ocon_rec HZ_PARTY_CONTACT_V2PUB.ORG_CONTACT_REC_TYPE;
2096: l_contact_points_rec_type hz_contact_point_v2pub.contact_point_rec_type;
2097: l_email_rec_type hz_contact_point_v2pub.email_rec_type;
2098: l_phone_rec_type hz_contact_point_v2pub.phone_rec_type;
2099:
2100: l_return_status varchar2(100);
2101: l_msg_count number;
2102: l_msg_data varchar2(2000);