DBA Data[Home] [Help]

APPS.HZ_MERGE_ENTITY_ATTRI_PVT dependencies on FND_MSG_PUB

Line 491: FND_MSG_PUB.ADD;

487: EXCEPTION
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:

Line 807: FND_MSG_PUB.ADD;

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

Line 952: FND_MSG_PUB.ADD;

948: EXCEPTION
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:

Line 1542: FND_MSG_PUB.ADD;

1538: EXCEPTION
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:

Line 1616: FND_MSG_PUB.ADD;

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

Line 1798: FND_MSG_PUB.Count_And_Get(

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

Line 1806: FND_MSG_PUB.Count_And_Get(

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

Line 1816: FND_MSG_PUB.ADD;

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(
1818: p_encoded => FND_API.G_FALSE,
1819: p_count => x_msg_count,
1820: p_data => x_msg_data);

Line 1817: FND_MSG_PUB.Count_And_Get(

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(
1818: p_encoded => FND_API.G_FALSE,
1819: p_count => x_msg_count,
1820: p_data => x_msg_data);
1821:

Line 1911: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1907: fetch get_obj_version_number_csr into l_object_version_number;
1908: close get_obj_version_number_csr;
1909:
1910: IF (l_object_version_number <> px_object_version_number) THEN
1911: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
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;

Line 1915: FND_MSG_PUB.ADD;

1911: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
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:

Line 1979: FND_MSG_PUB.Count_And_Get(

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

Line 1987: FND_MSG_PUB.Count_And_Get(

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

Line 1997: FND_MSG_PUB.ADD;

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(
1999: p_encoded => FND_API.G_FALSE,
2000: p_count => x_msg_count,
2001: p_data => x_msg_data);

Line 1998: FND_MSG_PUB.Count_And_Get(

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(
1999: p_encoded => FND_API.G_FALSE,
2000: p_count => x_msg_count,
2001: p_data => x_msg_data);
2002:

Line 2278: FND_MSG_PUB.ADD;

2274: EXCEPTION
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;