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_MERGE_ENTITY_ATTRI_PVT dependencies on FND_API

Line 108: x_return_status := FND_API.G_RET_STS_SUCCESS;

104: l_organization_rec HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE;
105: l_attribute_date_value date; -- Bug No:3729832
106: begin
107: -- Initialize return status to SUCCESS
108: x_return_status := FND_API.G_RET_STS_SUCCESS;
109:
110: open get_org_rec_csr;
111: loop
112: fetch get_org_rec_csr into l_attribute_name, l_attribute_value, l_attribute_type,l_attribute_party_id;

Line 492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

488: WHEN OTHERS THEN
489: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
490: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
491: FND_MSG_PUB.ADD;
492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
493:
494: End construct_organization_rec;
495:
496: /* private procedures, called in do_profile_attribute_merge */

Line 518: x_return_status := FND_API.G_RET_STS_SUCCESS;

514: l_person_rec HZ_PARTY_V2PUB.PERSON_REC_TYPE;
515: l_attribute_date_value date; -- Bug No:3729832
516: begin
517: -- Initialize return status to SUCCESS
518: x_return_status := FND_API.G_RET_STS_SUCCESS;
519:
520: open get_person_rec_csr;
521: loop
522: fetch get_person_rec_csr into l_attribute_name, l_attribute_value, l_attribute_type;

Line 808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

804: WHEN OTHERS THEN
805: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
806: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
807: FND_MSG_PUB.ADD;
808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
809: end construct_person_rec;
810:
811: /* procedure called in HZ_MERGE_PKG */
812: PROCEDURE do_profile_attribute_merge(

Line 852: x_return_status := FND_API.G_RET_STS_SUCCESS;

848: and rownum=1;
849:
850: begin
851: -- Initialize return status to SUCCESS
852: x_return_status := FND_API.G_RET_STS_SUCCESS;
853:
854: open get_automerge_flag_csr;
855: fetch get_automerge_flag_csr into l_automerge_flag;
856: close get_automerge_flag_csr;

Line 869: p_init_msg_list => FND_API.G_FALSE,

865:
866: Construct_organization_rec(p_merge_batch_id,p_merge_to_party_id,l_org_rec,x_return_status);
867:
868: Hz_party_v2pub.update_organization (
869: p_init_msg_list => FND_API.G_FALSE,
870: p_organization_rec => l_org_rec,
871: p_party_object_version_number =>l_object_version_number,
872: x_profile_id => l_profile_id,
873: x_return_status => x_return_status,

Line 905: p_init_msg_list => FND_API.G_FALSE,

901:
902: Construct_person_rec(p_merge_batch_id, p_merge_to_party_id, l_orig_sys_ref,l_person_rec,x_return_status);
903:
904: Hz_party_v2pub.update_person (
905: p_init_msg_list => FND_API.G_FALSE,
906: p_person_rec => l_person_rec,
907: p_party_object_version_number => l_object_version_number,
908: x_profile_id => l_profile_id,
909: x_return_status => x_return_status,

Line 953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

949: WHEN OTHERS THEN
950: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
951: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
952: FND_MSG_PUB.ADD;
953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
954:
955: end do_profile_attribute_merge;
956:
957: -- private procedures, called in create_merge_attributes

Line 1436: x_return_status := fnd_api.g_ret_sts_success;

1432: l_str varchar2(2000);
1433: l_attri_party_id number;
1434: l_derived_date date;
1435: begin
1436: x_return_status := fnd_api.g_ret_sts_success;
1437: l_attri_def_next_prof := nvl(fnd_profile.value('HZ_PROF_ATTR_DEFAULT_NEXT'), 'LATEST_UPDATE_DATE');
1438: if l_attri_def_next_prof = 'LATEST_UPDATE_DATE'
1439: then
1440: l_date_clause := 'LAST_UPDATE_DATE';

Line 1543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1539: WHEN OTHERS THEN
1540: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1541: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1542: FND_MSG_PUB.ADD;
1543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1544:
1545: end;
1546:
1547: /* private API */

Line 1611: x_return_status := FND_API.G_RET_STS_SUCCESS;

1607: l_selected_party_id number;
1608: begin
1609: savepoint create_merge_attributes_pvt;
1610: -- Initialize return status to SUCCESS
1611: x_return_status := FND_API.G_RET_STS_SUCCESS;
1612:
1613: if p_entity_name not in ('HZ_ORGANIZATION_PROFILES','HZ_PERSON_PROFILES')
1614: then
1615: FND_MESSAGE.SET_NAME( 'AR', 'HZ_INVALID_ENTITY_NAME' );

Line 1617: RAISE FND_API.G_EXC_ERROR;

1613: if p_entity_name not in ('HZ_ORGANIZATION_PROFILES','HZ_PERSON_PROFILES')
1614: then
1615: FND_MESSAGE.SET_NAME( 'AR', 'HZ_INVALID_ENTITY_NAME' );
1616: FND_MSG_PUB.ADD;
1617: RAISE FND_API.G_EXC_ERROR;
1618: end if;
1619:
1620: l_prof_value := nvl(fnd_profile.value('HZ_PROF_ATTR_DEFAULT'), 'MASTER');
1621: --dbms_output.put_line('profile value '|| l_prof_value);

Line 1651: if x_return_status = fnd_api.g_ret_sts_success

1647: x_msg_count => x_msg_count,
1648: x_msg_data => x_msg_data
1649: );
1650:
1651: if x_return_status = fnd_api.g_ret_sts_success
1652: then
1653: return; -- done all of the logic for this defaulting rule.
1654: elsif x_return_status = fnd_api.g_ret_sts_unexp_error
1655: then

Line 1654: elsif x_return_status = fnd_api.g_ret_sts_unexp_error

1650:
1651: if x_return_status = fnd_api.g_ret_sts_success
1652: then
1653: return; -- done all of the logic for this defaulting rule.
1654: elsif x_return_status = fnd_api.g_ret_sts_unexp_error
1655: then
1656: raise fnd_api.g_exc_unexpected_error;
1657: end if;
1658:

Line 1656: raise fnd_api.g_exc_unexpected_error;

1652: then
1653: return; -- done all of the logic for this defaulting rule.
1654: elsif x_return_status = fnd_api.g_ret_sts_unexp_error
1655: then
1656: raise fnd_api.g_exc_unexpected_error;
1657: end if;
1658:
1659: end if;
1660:

Line 1795: WHEN FND_API.G_EXC_ERROR THEN

1791:
1792:
1793: EXCEPTION
1794:
1795: WHEN FND_API.G_EXC_ERROR THEN
1796: ROLLBACK TO create_merge_attributes_pvt;
1797: x_return_status := FND_API.G_RET_STS_ERROR;
1798: FND_MSG_PUB.Count_And_Get(
1799: p_encoded => FND_API.G_FALSE,

Line 1797: x_return_status := FND_API.G_RET_STS_ERROR;

1793: EXCEPTION
1794:
1795: WHEN FND_API.G_EXC_ERROR THEN
1796: ROLLBACK TO create_merge_attributes_pvt;
1797: x_return_status := FND_API.G_RET_STS_ERROR;
1798: FND_MSG_PUB.Count_And_Get(
1799: p_encoded => FND_API.G_FALSE,
1800: p_count => x_msg_count,
1801: p_data => x_msg_data);

Line 1799: p_encoded => FND_API.G_FALSE,

1795: WHEN FND_API.G_EXC_ERROR THEN
1796: ROLLBACK TO create_merge_attributes_pvt;
1797: x_return_status := FND_API.G_RET_STS_ERROR;
1798: FND_MSG_PUB.Count_And_Get(
1799: p_encoded => FND_API.G_FALSE,
1800: p_count => x_msg_count,
1801: p_data => x_msg_data);
1802:
1803: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1803: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1799: p_encoded => FND_API.G_FALSE,
1800: p_count => x_msg_count,
1801: p_data => x_msg_data);
1802:
1803: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1804: ROLLBACK TO create_merge_attributes_pvt;
1805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1806: FND_MSG_PUB.Count_And_Get(
1807: p_encoded => FND_API.G_FALSE,

Line 1805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1801: p_data => x_msg_data);
1802:
1803: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1804: ROLLBACK TO create_merge_attributes_pvt;
1805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1806: FND_MSG_PUB.Count_And_Get(
1807: p_encoded => FND_API.G_FALSE,
1808: p_count => x_msg_count,
1809: p_data => x_msg_data);

Line 1807: p_encoded => FND_API.G_FALSE,

1803: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1804: ROLLBACK TO create_merge_attributes_pvt;
1805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1806: FND_MSG_PUB.Count_And_Get(
1807: p_encoded => FND_API.G_FALSE,
1808: p_count => x_msg_count,
1809: p_data => x_msg_data);
1810:
1811: WHEN OTHERS THEN

Line 1813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1809: p_data => x_msg_data);
1810:
1811: WHEN OTHERS THEN
1812: ROLLBACK TO create_merge_attributes_pvt;
1813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1814: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1815: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1816: FND_MSG_PUB.ADD;
1817: FND_MSG_PUB.Count_And_Get(

Line 1818: p_encoded => FND_API.G_FALSE,

1814: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1815: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1816: FND_MSG_PUB.ADD;
1817: FND_MSG_PUB.Count_And_Get(
1818: p_encoded => FND_API.G_FALSE,
1819: p_count => x_msg_count,
1820: p_data => x_msg_data);
1821:
1822: end create_merge_attributes;

Line 1890: x_return_status := FND_API.G_RET_STS_SUCCESS;

1886: begin
1887:
1888: savepoint update_merge_attributes_pvt;
1889: -- Initialize return status to SUCCESS
1890: x_return_status := FND_API.G_RET_STS_SUCCESS;
1891:
1892: if p_entity_name = 'HZ_ORGANIZATION_PROFILES'
1893: then
1894: l_lookup_type := 'ORG_PROFILE_CATEGORY';

Line 1916: RAISE FND_API.G_EXC_ERROR;

1912: -- row has been changed by another user.
1913: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1914: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_MERGE_ENTITY_ATTRIBUTES');
1915: FND_MSG_PUB.ADD;
1916: RAISE FND_API.G_EXC_ERROR;
1917: END IF;
1918: END IF;
1919:
1920: px_object_version_number := nvl(l_object_version_number,1)+1;

Line 1976: WHEN FND_API.G_EXC_ERROR THEN

1972: WHERE DUP_SET_ID = p_merge_batch_id;
1973:
1974: EXCEPTION
1975:
1976: WHEN FND_API.G_EXC_ERROR THEN
1977: ROLLBACK TO update_merge_attributes_pvt;
1978: x_return_status := FND_API.G_RET_STS_ERROR;
1979: FND_MSG_PUB.Count_And_Get(
1980: p_encoded => FND_API.G_FALSE,

Line 1978: x_return_status := FND_API.G_RET_STS_ERROR;

1974: EXCEPTION
1975:
1976: WHEN FND_API.G_EXC_ERROR THEN
1977: ROLLBACK TO update_merge_attributes_pvt;
1978: x_return_status := FND_API.G_RET_STS_ERROR;
1979: FND_MSG_PUB.Count_And_Get(
1980: p_encoded => FND_API.G_FALSE,
1981: p_count => x_msg_count,
1982: p_data => x_msg_data);

Line 1980: p_encoded => FND_API.G_FALSE,

1976: WHEN FND_API.G_EXC_ERROR THEN
1977: ROLLBACK TO update_merge_attributes_pvt;
1978: x_return_status := FND_API.G_RET_STS_ERROR;
1979: FND_MSG_PUB.Count_And_Get(
1980: p_encoded => FND_API.G_FALSE,
1981: p_count => x_msg_count,
1982: p_data => x_msg_data);
1983:
1984: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1984: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1980: p_encoded => FND_API.G_FALSE,
1981: p_count => x_msg_count,
1982: p_data => x_msg_data);
1983:
1984: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1985: ROLLBACK TO update_merge_attributes_pvt ;
1986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1987: FND_MSG_PUB.Count_And_Get(
1988: p_encoded => FND_API.G_FALSE,

Line 1986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1982: p_data => x_msg_data);
1983:
1984: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1985: ROLLBACK TO update_merge_attributes_pvt ;
1986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1987: FND_MSG_PUB.Count_And_Get(
1988: p_encoded => FND_API.G_FALSE,
1989: p_count => x_msg_count,
1990: p_data => x_msg_data);

Line 1988: p_encoded => FND_API.G_FALSE,

1984: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1985: ROLLBACK TO update_merge_attributes_pvt ;
1986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1987: FND_MSG_PUB.Count_And_Get(
1988: p_encoded => FND_API.G_FALSE,
1989: p_count => x_msg_count,
1990: p_data => x_msg_data);
1991:
1992: WHEN OTHERS THEN

Line 1994: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1990: p_data => x_msg_data);
1991:
1992: WHEN OTHERS THEN
1993: ROLLBACK TO update_merge_attributes_pvt;
1994: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1995: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1996: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1997: FND_MSG_PUB.ADD;
1998: FND_MSG_PUB.Count_And_Get(

Line 1999: p_encoded => FND_API.G_FALSE,

1995: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1996: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1997: FND_MSG_PUB.ADD;
1998: FND_MSG_PUB.Count_And_Get(
1999: p_encoded => FND_API.G_FALSE,
2000: p_count => x_msg_count,
2001: p_data => x_msg_data);
2002:
2003: end update_merge_attribute;

Line 2213: x_return_status := FND_API.G_RET_STS_SUCCESS;

2209: l_derived_last_upd_date date;
2210: l_party_last_upd_date date;
2211: begin
2212: -- Initialize return status to SUCCESS
2213: x_return_status := FND_API.G_RET_STS_SUCCESS;
2214:
2215: if is_attri_party_data_changed(p_merge_batch_id, p_entity_name) = 'N'
2216: then
2217: --dbms_output.put_line('no data change');

Line 2279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2275: WHEN OTHERS THEN
2276: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2277: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2278: FND_MSG_PUB.ADD;
2279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2280: end sync_merge_attributes;
2281:
2282: END HZ_MERGE_ENTITY_ATTRI_PVT;