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.CSI_PARTY_RELATIONSHIPS_PVT dependencies on FND_MESSAGE

Line 261: -- FND_MESSAGE.SET_NAME('CSI','CSI_H_DATE_BEFORE_CRE_DATE');

257: -- If the user chooses a date before the creation date of the instance
258: -- then raise an error
259: IF p_time_stamp < l_time_stamp THEN
260: -- Messages Commented for bug 2423342. Records that do not qualify should get deleted.
261: -- FND_MESSAGE.SET_NAME('CSI','CSI_H_DATE_BEFORE_CRE_DATE');
262: -- FND_MESSAGE.SET_TOKEN('CREATION_DATE',to_char(l_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
263: -- FND_MESSAGE.SET_TOKEN('USER_DATE',to_char(p_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
264: -- FND_MSG_PUB.Add;
265: -- RAISE FND_API.G_EXC_ERROR;

Line 262: -- FND_MESSAGE.SET_TOKEN('CREATION_DATE',to_char(l_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));

258: -- then raise an error
259: IF p_time_stamp < l_time_stamp THEN
260: -- Messages Commented for bug 2423342. Records that do not qualify should get deleted.
261: -- FND_MESSAGE.SET_NAME('CSI','CSI_H_DATE_BEFORE_CRE_DATE');
262: -- FND_MESSAGE.SET_TOKEN('CREATION_DATE',to_char(l_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
263: -- FND_MESSAGE.SET_TOKEN('USER_DATE',to_char(p_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
264: -- FND_MSG_PUB.Add;
265: -- RAISE FND_API.G_EXC_ERROR;
266: l_party_account_tbl.DELETE(i);

Line 263: -- FND_MESSAGE.SET_TOKEN('USER_DATE',to_char(p_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));

259: IF p_time_stamp < l_time_stamp THEN
260: -- Messages Commented for bug 2423342. Records that do not qualify should get deleted.
261: -- FND_MESSAGE.SET_NAME('CSI','CSI_H_DATE_BEFORE_CRE_DATE');
262: -- FND_MESSAGE.SET_TOKEN('CREATION_DATE',to_char(l_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
263: -- FND_MESSAGE.SET_TOKEN('USER_DATE',to_char(p_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
264: -- FND_MSG_PUB.Add;
265: -- RAISE FND_API.G_EXC_ERROR;
266: l_party_account_tbl.DELETE(i);
267: RAISE Process_next;

Line 1024: -- FND_MESSAGE.SET_NAME('CSI','CSI_H_DATE_BEFORE_CRE_DATE');

1020: -- If the user chooses a date before the creation date of the instance
1021: -- then raise an error
1022: IF p_time_stamp < l_time_stamp THEN
1023: -- Messages Commented for bug 2423342. Records that do not qualify should get deleted.
1024: -- FND_MESSAGE.SET_NAME('CSI','CSI_H_DATE_BEFORE_CRE_DATE');
1025: -- FND_MESSAGE.SET_TOKEN('CREATION_DATE',to_char(l_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
1026: -- FND_MESSAGE.SET_TOKEN('USER_DATE',to_char(p_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
1027: -- FND_MSG_PUB.Add;
1028: -- RAISE FND_API.G_EXC_ERROR;

Line 1025: -- FND_MESSAGE.SET_TOKEN('CREATION_DATE',to_char(l_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));

1021: -- then raise an error
1022: IF p_time_stamp < l_time_stamp THEN
1023: -- Messages Commented for bug 2423342. Records that do not qualify should get deleted.
1024: -- FND_MESSAGE.SET_NAME('CSI','CSI_H_DATE_BEFORE_CRE_DATE');
1025: -- FND_MESSAGE.SET_TOKEN('CREATION_DATE',to_char(l_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
1026: -- FND_MESSAGE.SET_TOKEN('USER_DATE',to_char(p_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
1027: -- FND_MSG_PUB.Add;
1028: -- RAISE FND_API.G_EXC_ERROR;
1029: l_party_tbl.DELETE(i);

Line 1026: -- FND_MESSAGE.SET_TOKEN('USER_DATE',to_char(p_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));

1022: IF p_time_stamp < l_time_stamp THEN
1023: -- Messages Commented for bug 2423342. Records that do not qualify should get deleted.
1024: -- FND_MESSAGE.SET_NAME('CSI','CSI_H_DATE_BEFORE_CRE_DATE');
1025: -- FND_MESSAGE.SET_TOKEN('CREATION_DATE',to_char(l_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
1026: -- FND_MESSAGE.SET_TOKEN('USER_DATE',to_char(p_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
1027: -- FND_MSG_PUB.Add;
1028: -- RAISE FND_API.G_EXC_ERROR;
1029: l_party_tbl.DELETE(i);
1030: RAISE Process_next;

Line 1671: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PARTY_SOURCE');

1667: END IF;
1668: END LOOP;
1669: --
1670: IF l_valid_flag <> 'Y' THEN
1671: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PARTY_SOURCE');
1672: FND_MESSAGE.SET_TOKEN('PARTY_SOURCE_TABLE',p_party_rec.PARTY_SOURCE_TABLE);
1673: FND_MSG_PUB.Add;
1674: RAISE FND_API.G_EXC_ERROR;
1675: END IF;

Line 1672: FND_MESSAGE.SET_TOKEN('PARTY_SOURCE_TABLE',p_party_rec.PARTY_SOURCE_TABLE);

1668: END LOOP;
1669: --
1670: IF l_valid_flag <> 'Y' THEN
1671: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PARTY_SOURCE');
1672: FND_MESSAGE.SET_TOKEN('PARTY_SOURCE_TABLE',p_party_rec.PARTY_SOURCE_TABLE);
1673: FND_MSG_PUB.Add;
1674: RAISE FND_API.G_EXC_ERROR;
1675: END IF;
1676: END IF;

Line 1706: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PARTY_ID');

1702: exit;
1703: END IF;
1704: --
1705: IF l_valid_flag <> 'Y' THEN
1706: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PARTY_ID');
1707: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_rec.PARTY_ID);
1708: FND_MSG_PUB.Add;
1709: RAISE FND_API.G_EXC_ERROR;
1710: END IF;

Line 1707: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_rec.PARTY_ID);

1703: END IF;
1704: --
1705: IF l_valid_flag <> 'Y' THEN
1706: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PARTY_ID');
1707: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_rec.PARTY_ID);
1708: FND_MSG_PUB.Add;
1709: RAISE FND_API.G_EXC_ERROR;
1710: END IF;
1711: END LOOP;

Line 1737: FND_MESSAGE.SET_NAME('CSI', 'CSI_INVALID_OWNER_CONTACT');

1733: -- Contact_flag for the owner party should be 'N', if not then raise an error
1734: IF ((p_party_rec.relationship_type_code = 'OWNER')
1735: AND (p_party_rec.contact_flag = 'Y'))
1736: THEN
1737: FND_MESSAGE.SET_NAME('CSI', 'CSI_INVALID_OWNER_CONTACT');
1738: FND_MESSAGE.SET_TOKEN('CONTACT_FLAG', p_party_rec.CONTACT_FLAG);
1739: FND_MESSAGE.SET_TOKEN('RELATIONSHIP_TYPE_CODE', p_party_rec.RELATIONSHIP_TYPE_CODE);
1740: FND_MSG_PUB.ADD;
1741: RAISE FND_API.G_EXC_ERROR;

Line 1738: FND_MESSAGE.SET_TOKEN('CONTACT_FLAG', p_party_rec.CONTACT_FLAG);

1734: IF ((p_party_rec.relationship_type_code = 'OWNER')
1735: AND (p_party_rec.contact_flag = 'Y'))
1736: THEN
1737: FND_MESSAGE.SET_NAME('CSI', 'CSI_INVALID_OWNER_CONTACT');
1738: FND_MESSAGE.SET_TOKEN('CONTACT_FLAG', p_party_rec.CONTACT_FLAG);
1739: FND_MESSAGE.SET_TOKEN('RELATIONSHIP_TYPE_CODE', p_party_rec.RELATIONSHIP_TYPE_CODE);
1740: FND_MSG_PUB.ADD;
1741: RAISE FND_API.G_EXC_ERROR;
1742: END IF;

Line 1739: FND_MESSAGE.SET_TOKEN('RELATIONSHIP_TYPE_CODE', p_party_rec.RELATIONSHIP_TYPE_CODE);

1735: AND (p_party_rec.contact_flag = 'Y'))
1736: THEN
1737: FND_MESSAGE.SET_NAME('CSI', 'CSI_INVALID_OWNER_CONTACT');
1738: FND_MESSAGE.SET_TOKEN('CONTACT_FLAG', p_party_rec.CONTACT_FLAG);
1739: FND_MESSAGE.SET_TOKEN('RELATIONSHIP_TYPE_CODE', p_party_rec.RELATIONSHIP_TYPE_CODE);
1740: FND_MSG_PUB.ADD;
1741: RAISE FND_API.G_EXC_ERROR;
1742: END IF;
1743: --

Line 1750: FND_MESSAGE.SET_NAME('CSI', 'CSI_CANNOT_CREATE_CONTACT');

1746: THEN
1747: IF ((p_party_rec.CONTACT_IP_ID <> FND_API.G_MISS_NUM)
1748: AND (p_party_rec.CONTACT_IP_ID IS NOT NULL))
1749: THEN
1750: FND_MESSAGE.SET_NAME('CSI', 'CSI_CANNOT_CREATE_CONTACT');
1751: FND_MESSAGE.SET_TOKEN('CONTACT_FLAG', p_party_rec.CONTACT_FLAG);
1752: FND_MESSAGE.SET_TOKEN('CONTACT_IP_ID', p_party_rec.CONTACT_IP_ID);
1753: FND_MSG_PUB.ADD;
1754: RAISE FND_API.G_EXC_ERROR;

Line 1751: FND_MESSAGE.SET_TOKEN('CONTACT_FLAG', p_party_rec.CONTACT_FLAG);

1747: IF ((p_party_rec.CONTACT_IP_ID <> FND_API.G_MISS_NUM)
1748: AND (p_party_rec.CONTACT_IP_ID IS NOT NULL))
1749: THEN
1750: FND_MESSAGE.SET_NAME('CSI', 'CSI_CANNOT_CREATE_CONTACT');
1751: FND_MESSAGE.SET_TOKEN('CONTACT_FLAG', p_party_rec.CONTACT_FLAG);
1752: FND_MESSAGE.SET_TOKEN('CONTACT_IP_ID', p_party_rec.CONTACT_IP_ID);
1753: FND_MSG_PUB.ADD;
1754: RAISE FND_API.G_EXC_ERROR;
1755: END IF;

Line 1752: FND_MESSAGE.SET_TOKEN('CONTACT_IP_ID', p_party_rec.CONTACT_IP_ID);

1748: AND (p_party_rec.CONTACT_IP_ID IS NOT NULL))
1749: THEN
1750: FND_MESSAGE.SET_NAME('CSI', 'CSI_CANNOT_CREATE_CONTACT');
1751: FND_MESSAGE.SET_TOKEN('CONTACT_FLAG', p_party_rec.CONTACT_FLAG);
1752: FND_MESSAGE.SET_TOKEN('CONTACT_IP_ID', p_party_rec.CONTACT_IP_ID);
1753: FND_MSG_PUB.ADD;
1754: RAISE FND_API.G_EXC_ERROR;
1755: END IF;
1756: END IF;

Line 1775: FND_MESSAGE.SET_NAME('CSI', 'CSI_INVALID_CONTACT_ID');

1771: WHERE instance_id <> p_party_rec.INSTANCE_ID
1772: AND instance_party_id = p_party_rec.CONTACT_IP_ID;
1773:
1774: IF l_exists IS NOT NULL THEN
1775: FND_MESSAGE.SET_NAME('CSI', 'CSI_INVALID_CONTACT_ID');
1776: FND_MESSAGE.SET_TOKEN('CONTACT_FLAG', p_party_rec.CONTACT_FLAG);
1777: FND_MESSAGE.SET_TOKEN('CONTACT_IP_ID', p_party_rec.CONTACT_IP_ID);
1778: FND_MSG_PUB.Add;
1779: RAISE FND_API.G_EXC_ERROR;

Line 1776: FND_MESSAGE.SET_TOKEN('CONTACT_FLAG', p_party_rec.CONTACT_FLAG);

1772: AND instance_party_id = p_party_rec.CONTACT_IP_ID;
1773:
1774: IF l_exists IS NOT NULL THEN
1775: FND_MESSAGE.SET_NAME('CSI', 'CSI_INVALID_CONTACT_ID');
1776: FND_MESSAGE.SET_TOKEN('CONTACT_FLAG', p_party_rec.CONTACT_FLAG);
1777: FND_MESSAGE.SET_TOKEN('CONTACT_IP_ID', p_party_rec.CONTACT_IP_ID);
1778: FND_MSG_PUB.Add;
1779: RAISE FND_API.G_EXC_ERROR;
1780: END IF;

Line 1777: FND_MESSAGE.SET_TOKEN('CONTACT_IP_ID', p_party_rec.CONTACT_IP_ID);

1773:
1774: IF l_exists IS NOT NULL THEN
1775: FND_MESSAGE.SET_NAME('CSI', 'CSI_INVALID_CONTACT_ID');
1776: FND_MESSAGE.SET_TOKEN('CONTACT_FLAG', p_party_rec.CONTACT_FLAG);
1777: FND_MESSAGE.SET_TOKEN('CONTACT_IP_ID', p_party_rec.CONTACT_IP_ID);
1778: FND_MSG_PUB.Add;
1779: RAISE FND_API.G_EXC_ERROR;
1780: END IF;
1781: EXCEPTION

Line 1786: FND_MESSAGE.SET_NAME('CSI', 'CSI_INVALID_CONTACT_ID');

1782: WHEN NO_DATA_FOUND THEN
1783: NULL;
1784: END;
1785: ELSE
1786: FND_MESSAGE.SET_NAME('CSI', 'CSI_INVALID_CONTACT_ID');
1787: FND_MESSAGE.SET_TOKEN('CONTACT_FLAG', p_party_rec.CONTACT_FLAG);
1788: FND_MESSAGE.SET_TOKEN('CONTACT_IP_ID', p_party_rec.CONTACT_IP_ID);
1789: FND_MSG_PUB.Add;
1790: RAISE FND_API.G_EXC_ERROR;

Line 1787: FND_MESSAGE.SET_TOKEN('CONTACT_FLAG', p_party_rec.CONTACT_FLAG);

1783: NULL;
1784: END;
1785: ELSE
1786: FND_MESSAGE.SET_NAME('CSI', 'CSI_INVALID_CONTACT_ID');
1787: FND_MESSAGE.SET_TOKEN('CONTACT_FLAG', p_party_rec.CONTACT_FLAG);
1788: FND_MESSAGE.SET_TOKEN('CONTACT_IP_ID', p_party_rec.CONTACT_IP_ID);
1789: FND_MSG_PUB.Add;
1790: RAISE FND_API.G_EXC_ERROR;
1791: END IF;

Line 1788: FND_MESSAGE.SET_TOKEN('CONTACT_IP_ID', p_party_rec.CONTACT_IP_ID);

1784: END;
1785: ELSE
1786: FND_MESSAGE.SET_NAME('CSI', 'CSI_INVALID_CONTACT_ID');
1787: FND_MESSAGE.SET_TOKEN('CONTACT_FLAG', p_party_rec.CONTACT_FLAG);
1788: FND_MESSAGE.SET_TOKEN('CONTACT_IP_ID', p_party_rec.CONTACT_IP_ID);
1789: FND_MSG_PUB.Add;
1790: RAISE FND_API.G_EXC_ERROR;
1791: END IF;
1792: END IF;

Line 1818: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_CONTACT_INFO');

1814: END LOOP;
1815: --
1816: /*
1817: IF l_valid_flag <> 'Y' THEN
1818: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_CONTACT_INFO');
1819: FND_MESSAGE.SET_TOKEN('CONTACT_PARTY_ID',p_party_rec.PARTY_ID);
1820: FND_MESSAGE.SET_TOKEN('CONTACT_SOURCE_TABLE',p_party_rec.PARTY_SOURCE_TABLE);
1821: FND_MSG_PUB.Add;
1822: RAISE FND_API.G_EXC_ERROR;

Line 1819: FND_MESSAGE.SET_TOKEN('CONTACT_PARTY_ID',p_party_rec.PARTY_ID);

1815: --
1816: /*
1817: IF l_valid_flag <> 'Y' THEN
1818: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_CONTACT_INFO');
1819: FND_MESSAGE.SET_TOKEN('CONTACT_PARTY_ID',p_party_rec.PARTY_ID);
1820: FND_MESSAGE.SET_TOKEN('CONTACT_SOURCE_TABLE',p_party_rec.PARTY_SOURCE_TABLE);
1821: FND_MSG_PUB.Add;
1822: RAISE FND_API.G_EXC_ERROR;
1823: END IF;

Line 1820: FND_MESSAGE.SET_TOKEN('CONTACT_SOURCE_TABLE',p_party_rec.PARTY_SOURCE_TABLE);

1816: /*
1817: IF l_valid_flag <> 'Y' THEN
1818: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_CONTACT_INFO');
1819: FND_MESSAGE.SET_TOKEN('CONTACT_PARTY_ID',p_party_rec.PARTY_ID);
1820: FND_MESSAGE.SET_TOKEN('CONTACT_SOURCE_TABLE',p_party_rec.PARTY_SOURCE_TABLE);
1821: FND_MSG_PUB.Add;
1822: RAISE FND_API.G_EXC_ERROR;
1823: END IF;
1824: */ -- code commented by sguthiva for bug 2619247.

Line 1861: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_PARTY_TYPE_CODE');

1857: END IF;
1858: END LOOP;
1859: --
1860: IF l_valid_flag <> 'Y' THEN
1861: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_PARTY_TYPE_CODE');
1862: FND_MESSAGE.SET_TOKEN('RELATIONSHIP_TYPE_CODE',p_party_rec.RELATIONSHIP_TYPE_CODE);
1863: FND_MSG_PUB.Add;
1864: RAISE FND_API.G_EXC_ERROR;
1865: END IF;

Line 1862: FND_MESSAGE.SET_TOKEN('RELATIONSHIP_TYPE_CODE',p_party_rec.RELATIONSHIP_TYPE_CODE);

1858: END LOOP;
1859: --
1860: IF l_valid_flag <> 'Y' THEN
1861: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_PARTY_TYPE_CODE');
1862: FND_MESSAGE.SET_TOKEN('RELATIONSHIP_TYPE_CODE',p_party_rec.RELATIONSHIP_TYPE_CODE);
1863: FND_MSG_PUB.Add;
1864: RAISE FND_API.G_EXC_ERROR;
1865: END IF;
1866: END IF;

Line 1898: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_PARTY_TYPE_CODE');

1894: END IF;
1895: END LOOP;
1896: --
1897: IF l_valid_flag <> 'Y' THEN
1898: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_PARTY_TYPE_CODE');
1899: FND_MESSAGE.SET_TOKEN('RELATIONSHIP_TYPE_CODE',p_party_rec.RELATIONSHIP_TYPE_CODE);
1900: FND_MSG_PUB.Add;
1901: RAISE FND_API.G_EXC_ERROR;
1902: END IF;

Line 1899: FND_MESSAGE.SET_TOKEN('RELATIONSHIP_TYPE_CODE',p_party_rec.RELATIONSHIP_TYPE_CODE);

1895: END LOOP;
1896: --
1897: IF l_valid_flag <> 'Y' THEN
1898: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_PARTY_TYPE_CODE');
1899: FND_MESSAGE.SET_TOKEN('RELATIONSHIP_TYPE_CODE',p_party_rec.RELATIONSHIP_TYPE_CODE);
1900: FND_MSG_PUB.Add;
1901: RAISE FND_API.G_EXC_ERROR;
1902: END IF;
1903: END IF;

Line 1967: FND_MESSAGE.SET_NAME('CSI','CSI_PREFERRED_PTY_TYPE');

1963: -- given instance party relationship
1964: IF p_party_rec.PREFERRED_FLAG = 'Y' THEN
1965: IF p_party_rec.CONTACT_FLAG <> 'Y' THEN
1966: IF p_party_rec.PARTY_SOURCE_TABLE NOT IN ('GROUP','TEAM') THEN
1967: FND_MESSAGE.SET_NAME('CSI','CSI_PREFERRED_PTY_TYPE');
1968: FND_MESSAGE.SET_TOKEN('PARTY_TYPE',p_party_rec.PARTY_SOURCE_TABLE);
1969: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_party_rec.INSTANCE_ID);
1970: FND_MSG_PUB.Add;
1971: RAISE FND_API.G_EXC_ERROR;

Line 1968: FND_MESSAGE.SET_TOKEN('PARTY_TYPE',p_party_rec.PARTY_SOURCE_TABLE);

1964: IF p_party_rec.PREFERRED_FLAG = 'Y' THEN
1965: IF p_party_rec.CONTACT_FLAG <> 'Y' THEN
1966: IF p_party_rec.PARTY_SOURCE_TABLE NOT IN ('GROUP','TEAM') THEN
1967: FND_MESSAGE.SET_NAME('CSI','CSI_PREFERRED_PTY_TYPE');
1968: FND_MESSAGE.SET_TOKEN('PARTY_TYPE',p_party_rec.PARTY_SOURCE_TABLE);
1969: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_party_rec.INSTANCE_ID);
1970: FND_MSG_PUB.Add;
1971: RAISE FND_API.G_EXC_ERROR;
1972: END IF;

Line 1969: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_party_rec.INSTANCE_ID);

1965: IF p_party_rec.CONTACT_FLAG <> 'Y' THEN
1966: IF p_party_rec.PARTY_SOURCE_TABLE NOT IN ('GROUP','TEAM') THEN
1967: FND_MESSAGE.SET_NAME('CSI','CSI_PREFERRED_PTY_TYPE');
1968: FND_MESSAGE.SET_TOKEN('PARTY_TYPE',p_party_rec.PARTY_SOURCE_TABLE);
1969: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_party_rec.INSTANCE_ID);
1970: FND_MSG_PUB.Add;
1971: RAISE FND_API.G_EXC_ERROR;
1972: END IF;
1973: END IF;

Line 1991: FND_MESSAGE.SET_NAME('CSI','CSI_PRIMARY_PTY_TYPE');

1987: RAISE FND_API.G_EXC_ERROR;
1988: END IF;
1989: ELSE
1990: IF p_party_rec.PARTY_SOURCE_TABLE NOT IN ('GROUP','TEAM') THEN
1991: FND_MESSAGE.SET_NAME('CSI','CSI_PRIMARY_PTY_TYPE');
1992: FND_MESSAGE.SET_TOKEN('PARTY_TYPE',p_party_rec.PARTY_SOURCE_TABLE);
1993: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_party_rec.INSTANCE_ID);
1994: FND_MSG_PUB.Add;
1995: RAISE FND_API.G_EXC_ERROR;

Line 1992: FND_MESSAGE.SET_TOKEN('PARTY_TYPE',p_party_rec.PARTY_SOURCE_TABLE);

1988: END IF;
1989: ELSE
1990: IF p_party_rec.PARTY_SOURCE_TABLE NOT IN ('GROUP','TEAM') THEN
1991: FND_MESSAGE.SET_NAME('CSI','CSI_PRIMARY_PTY_TYPE');
1992: FND_MESSAGE.SET_TOKEN('PARTY_TYPE',p_party_rec.PARTY_SOURCE_TABLE);
1993: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_party_rec.INSTANCE_ID);
1994: FND_MSG_PUB.Add;
1995: RAISE FND_API.G_EXC_ERROR;
1996: ELSE

Line 1993: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_party_rec.INSTANCE_ID);

1989: ELSE
1990: IF p_party_rec.PARTY_SOURCE_TABLE NOT IN ('GROUP','TEAM') THEN
1991: FND_MESSAGE.SET_NAME('CSI','CSI_PRIMARY_PTY_TYPE');
1992: FND_MESSAGE.SET_TOKEN('PARTY_TYPE',p_party_rec.PARTY_SOURCE_TABLE);
1993: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_party_rec.INSTANCE_ID);
1994: FND_MSG_PUB.Add;
1995: RAISE FND_API.G_EXC_ERROR;
1996: ELSE
1997: IF CSI_Instance_parties_vld_pvt.Is_Primary_Pty

Line 2039: fnd_message.set_name('CSI','CSI_PRIMARY_PTY_EXC');

2035: p_party_rec.primary_flag <> fnd_api.g_miss_char AND
2036: p_party_rec.primary_flag = 'Y' ) AND
2037: p_party_rec.preferred_flag='E'
2038: THEN
2039: fnd_message.set_name('CSI','CSI_PRIMARY_PTY_EXC');
2040: fnd_msg_pub.Add;
2041: RAISE fnd_api.g_exc_error;
2042: END IF;
2043:

Line 2052: fnd_message.set_name('CSI','CSI_PREFERRED_VALUES');

2048: p_party_rec.preferred_flag='E'
2049: THEN
2050: NULL;
2051: ELSE
2052: fnd_message.set_name('CSI','CSI_PREFERRED_VALUES');
2053: fnd_message.set_token('PREFERRED_FLAG',p_party_rec.preferred_flag);
2054: fnd_msg_pub.Add;
2055: RAISE fnd_api.g_exc_error;
2056: END IF;

Line 2053: fnd_message.set_token('PREFERRED_FLAG',p_party_rec.preferred_flag);

2049: THEN
2050: NULL;
2051: ELSE
2052: fnd_message.set_name('CSI','CSI_PREFERRED_VALUES');
2053: fnd_message.set_token('PREFERRED_FLAG',p_party_rec.preferred_flag);
2054: fnd_msg_pub.Add;
2055: RAISE fnd_api.g_exc_error;
2056: END IF;
2057:

Line 2608: FND_MESSAGE.SET_NAME('CSI','CSI_API_MANDATORY_PARTY');

2604: ' p_party_rec.INSTANCE_PARTY_ID ',
2605: l_api_name );
2606: --
2607: IF p_party_rec.party_id IS NULL THEN
2608: FND_MESSAGE.SET_NAME('CSI','CSI_API_MANDATORY_PARTY');
2609: FND_MSG_PUB.Add;
2610: RAISE FND_API.G_EXC_ERROR;
2611: END IF;
2612: --

Line 2670: FND_MESSAGE.Set_Name('CSI', 'CSI_API_OBJ_VER_MISMATCH');

2666: -- in the database else raise error
2667: OPEN get_curr_party_rec(p_party_rec.INSTANCE_PARTY_ID);
2668: FETCH get_curr_party_rec INTO l_curr_party_rec;
2669: IF (l_curr_party_rec.object_version_number <> p_party_rec.OBJECT_VERSION_NUMBER) THEN
2670: FND_MESSAGE.Set_Name('CSI', 'CSI_API_OBJ_VER_MISMATCH');
2671: FND_MSG_PUB.ADD;
2672: RAISE FND_API.G_EXC_ERROR;
2673: END IF;
2674: --

Line 2676: FND_MESSAGE.Set_Name('CSI', 'CSI_API_RECORD_LOCKED');

2672: RAISE FND_API.G_EXC_ERROR;
2673: END IF;
2674: --
2675: IF get_curr_party_rec%NOTFOUND THEN
2676: FND_MESSAGE.Set_Name('CSI', 'CSI_API_RECORD_LOCKED');
2677: FND_MSG_PUB.ADD;
2678: RAISE FND_API.G_EXC_ERROR;
2679: END IF;
2680: CLOSE get_curr_party_rec;

Line 2684: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');

2680: CLOSE get_curr_party_rec;
2681: --
2682: IF p_party_rec.instance_id <> FND_API.G_MISS_NUM THEN
2683: IF p_party_rec.instance_id <> l_curr_party_rec.instance_id THEN
2684: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
2685: FND_MESSAGE.Set_Token('COLUMN', 'INSTANCE_ID');
2686: FND_MSG_PUB.ADD;
2687: RAISE FND_API.G_EXC_ERROR;
2688: END IF;

Line 2685: FND_MESSAGE.Set_Token('COLUMN', 'INSTANCE_ID');

2681: --
2682: IF p_party_rec.instance_id <> FND_API.G_MISS_NUM THEN
2683: IF p_party_rec.instance_id <> l_curr_party_rec.instance_id THEN
2684: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
2685: FND_MESSAGE.Set_Token('COLUMN', 'INSTANCE_ID');
2686: FND_MSG_PUB.ADD;
2687: RAISE FND_API.G_EXC_ERROR;
2688: END IF;
2689: END IF;

Line 2692: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');

2688: END IF;
2689: END IF;
2690: --
2691: IF p_party_rec.active_start_date IS NULL THEN
2692: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
2693: FND_MESSAGE.Set_Token('COLUMN', 'ACTIVE_START_DATE');
2694: FND_MSG_PUB.ADD;
2695: RAISE FND_API.G_EXC_ERROR;
2696: END IF;

Line 2693: FND_MESSAGE.Set_Token('COLUMN', 'ACTIVE_START_DATE');

2689: END IF;
2690: --
2691: IF p_party_rec.active_start_date IS NULL THEN
2692: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
2693: FND_MESSAGE.Set_Token('COLUMN', 'ACTIVE_START_DATE');
2694: FND_MSG_PUB.ADD;
2695: RAISE FND_API.G_EXC_ERROR;
2696: END IF;
2697: --

Line 2700: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');

2696: END IF;
2697: --
2698: IF p_party_rec.active_start_date <> FND_API.G_MISS_DATE THEN
2699: IF p_party_rec.active_start_date <> l_curr_party_rec.active_start_date THEN
2700: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
2701: FND_MESSAGE.Set_Token('COLUMN', 'ACTIVE_START_DATE');
2702: FND_MSG_PUB.ADD;
2703: RAISE FND_API.G_EXC_ERROR;
2704: END IF;

Line 2701: FND_MESSAGE.Set_Token('COLUMN', 'ACTIVE_START_DATE');

2697: --
2698: IF p_party_rec.active_start_date <> FND_API.G_MISS_DATE THEN
2699: IF p_party_rec.active_start_date <> l_curr_party_rec.active_start_date THEN
2700: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
2701: FND_MESSAGE.Set_Token('COLUMN', 'ACTIVE_START_DATE');
2702: FND_MSG_PUB.ADD;
2703: RAISE FND_API.G_EXC_ERROR;
2704: END IF;
2705: END IF;

Line 2712: FND_MESSAGE.Set_Name('CSI', 'CSI_API_EXP_NOT_ALLOWED');

2708: -- Verify if the active_end_date is valid
2709: -- Don't allow expiry of owner parties
2710: IF p_party_rec.ACTIVE_END_DATE <> FND_API.G_MISS_DATE THEN
2711: IF l_curr_party_rec.relationship_type_code = 'OWNER' THEN
2712: FND_MESSAGE.Set_Name('CSI', 'CSI_API_EXP_NOT_ALLOWED');
2713: FND_MESSAGE.Set_Token('COLUMN', 'OWNER PARTY');
2714: FND_MSG_PUB.ADD;
2715: RAISE FND_API.G_EXC_ERROR;
2716: ELSE

Line 2713: FND_MESSAGE.Set_Token('COLUMN', 'OWNER PARTY');

2709: -- Don't allow expiry of owner parties
2710: IF p_party_rec.ACTIVE_END_DATE <> FND_API.G_MISS_DATE THEN
2711: IF l_curr_party_rec.relationship_type_code = 'OWNER' THEN
2712: FND_MESSAGE.Set_Name('CSI', 'CSI_API_EXP_NOT_ALLOWED');
2713: FND_MESSAGE.Set_Token('COLUMN', 'OWNER PARTY');
2714: FND_MSG_PUB.ADD;
2715: RAISE FND_API.G_EXC_ERROR;
2716: ELSE
2717: -- Verify if the active_end_date is valid

Line 2734: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');

2730: --
2731: IF p_party_rec.relationship_type_code <> FND_API.G_MISS_CHAR THEN
2732: IF ((p_party_rec.relationship_type_code <> l_curr_party_rec.relationship_type_code)
2733: AND l_curr_party_rec.relationship_type_code = 'OWNER' ) THEN
2734: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
2735: FND_MESSAGE.Set_Token('COLUMN', 'OWNER PARTY');
2736:
2737: FND_MSG_PUB.ADD;
2738: RAISE FND_API.G_EXC_ERROR;

Line 2735: FND_MESSAGE.Set_Token('COLUMN', 'OWNER PARTY');

2731: IF p_party_rec.relationship_type_code <> FND_API.G_MISS_CHAR THEN
2732: IF ((p_party_rec.relationship_type_code <> l_curr_party_rec.relationship_type_code)
2733: AND l_curr_party_rec.relationship_type_code = 'OWNER' ) THEN
2734: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
2735: FND_MESSAGE.Set_Token('COLUMN', 'OWNER PARTY');
2736:
2737: FND_MSG_PUB.ADD;
2738: RAISE FND_API.G_EXC_ERROR;
2739: ELSE

Line 2769: FND_MESSAGE.SET_NAME('CSI','CSI_PREFERRED_PTY_TYPE');

2765: IF p_party_rec.CONTACT_FLAG <> 'Y' THEN
2766: IF (((p_party_rec.PARTY_SOURCE_TABLE <> FND_API.G_MISS_CHAR)
2767: AND (p_party_rec.PARTY_SOURCE_TABLE NOT IN ('GROUP','TEAM')))
2768: OR (l_curr_party_rec.PARTY_SOURCE_TABLE NOT IN ('GROUP','TEAM'))) THEN
2769: FND_MESSAGE.SET_NAME('CSI','CSI_PREFERRED_PTY_TYPE');
2770: FND_MESSAGE.SET_TOKEN('PARTY_TYPE',l_curr_party_rec.PARTY_SOURCE_TABLE);
2771: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_curr_party_rec.INSTANCE_ID);
2772: FND_MSG_PUB.Add;
2773: RAISE FND_API.G_EXC_ERROR;

Line 2770: FND_MESSAGE.SET_TOKEN('PARTY_TYPE',l_curr_party_rec.PARTY_SOURCE_TABLE);

2766: IF (((p_party_rec.PARTY_SOURCE_TABLE <> FND_API.G_MISS_CHAR)
2767: AND (p_party_rec.PARTY_SOURCE_TABLE NOT IN ('GROUP','TEAM')))
2768: OR (l_curr_party_rec.PARTY_SOURCE_TABLE NOT IN ('GROUP','TEAM'))) THEN
2769: FND_MESSAGE.SET_NAME('CSI','CSI_PREFERRED_PTY_TYPE');
2770: FND_MESSAGE.SET_TOKEN('PARTY_TYPE',l_curr_party_rec.PARTY_SOURCE_TABLE);
2771: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_curr_party_rec.INSTANCE_ID);
2772: FND_MSG_PUB.Add;
2773: RAISE FND_API.G_EXC_ERROR;
2774: END IF;

Line 2771: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_curr_party_rec.INSTANCE_ID);

2767: AND (p_party_rec.PARTY_SOURCE_TABLE NOT IN ('GROUP','TEAM')))
2768: OR (l_curr_party_rec.PARTY_SOURCE_TABLE NOT IN ('GROUP','TEAM'))) THEN
2769: FND_MESSAGE.SET_NAME('CSI','CSI_PREFERRED_PTY_TYPE');
2770: FND_MESSAGE.SET_TOKEN('PARTY_TYPE',l_curr_party_rec.PARTY_SOURCE_TABLE);
2771: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_curr_party_rec.INSTANCE_ID);
2772: FND_MSG_PUB.Add;
2773: RAISE FND_API.G_EXC_ERROR;
2774: END IF;
2775: END IF;

Line 2831: /*FND_MESSAGE.SET_NAME('CSI','CSI_HAHA2');

2827: IF (((p_party_rec.PARTY_SOURCE_TABLE <> FND_API.G_MISS_CHAR)
2828: AND (p_party_rec.PARTY_SOURCE_TABLE NOT IN ('GROUP','TEAM')))
2829: OR (l_curr_party_rec.PARTY_SOURCE_TABLE NOT IN ('GROUP','TEAM'))) THEN
2830: -- following code is commented by sk
2831: /*FND_MESSAGE.SET_NAME('CSI','CSI_HAHA2');
2832: --FND_MESSAGE.SET_NAME('CSI','CSI_PRIMARY_PTY_TYPE');
2833: FND_MESSAGE.SET_TOKEN('PARTY_TYPE',l_curr_party_rec.PARTY_SOURCE_TABLE);
2834: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_curr_party_rec.INSTANCE_ID);
2835: FND_MSG_PUB.Add;

Line 2832: --FND_MESSAGE.SET_NAME('CSI','CSI_PRIMARY_PTY_TYPE');

2828: AND (p_party_rec.PARTY_SOURCE_TABLE NOT IN ('GROUP','TEAM')))
2829: OR (l_curr_party_rec.PARTY_SOURCE_TABLE NOT IN ('GROUP','TEAM'))) THEN
2830: -- following code is commented by sk
2831: /*FND_MESSAGE.SET_NAME('CSI','CSI_HAHA2');
2832: --FND_MESSAGE.SET_NAME('CSI','CSI_PRIMARY_PTY_TYPE');
2833: FND_MESSAGE.SET_TOKEN('PARTY_TYPE',l_curr_party_rec.PARTY_SOURCE_TABLE);
2834: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_curr_party_rec.INSTANCE_ID);
2835: FND_MSG_PUB.Add;
2836: RAISE FND_API.G_EXC_ERROR; */

Line 2833: FND_MESSAGE.SET_TOKEN('PARTY_TYPE',l_curr_party_rec.PARTY_SOURCE_TABLE);

2829: OR (l_curr_party_rec.PARTY_SOURCE_TABLE NOT IN ('GROUP','TEAM'))) THEN
2830: -- following code is commented by sk
2831: /*FND_MESSAGE.SET_NAME('CSI','CSI_HAHA2');
2832: --FND_MESSAGE.SET_NAME('CSI','CSI_PRIMARY_PTY_TYPE');
2833: FND_MESSAGE.SET_TOKEN('PARTY_TYPE',l_curr_party_rec.PARTY_SOURCE_TABLE);
2834: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_curr_party_rec.INSTANCE_ID);
2835: FND_MSG_PUB.Add;
2836: RAISE FND_API.G_EXC_ERROR; */
2837: NULL; --added by sk

Line 2834: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_curr_party_rec.INSTANCE_ID);

2830: -- following code is commented by sk
2831: /*FND_MESSAGE.SET_NAME('CSI','CSI_HAHA2');
2832: --FND_MESSAGE.SET_NAME('CSI','CSI_PRIMARY_PTY_TYPE');
2833: FND_MESSAGE.SET_TOKEN('PARTY_TYPE',l_curr_party_rec.PARTY_SOURCE_TABLE);
2834: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_curr_party_rec.INSTANCE_ID);
2835: FND_MSG_PUB.Add;
2836: RAISE FND_API.G_EXC_ERROR; */
2837: NULL; --added by sk
2838: ELSE

Line 2906: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');

2902: --
2903: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
2904: --
2905: IF l_internal_party_id IS NULL THEN
2906: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
2907: FND_MSG_PUB.ADD;
2908: RAISE FND_API.G_EXC_ERROR;
2909: END IF;
2910: -- Validate Tranfer Party rules in case of tranfer of instance

Line 3019: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PARTY_REL_COMB');

3015: END;
3016: EXCEPTION
3017: WHEN TOO_MANY_ROWS THEN
3018: csi_gen_utility_pvt.put_line('Too many rows exist in csi_i_parties with the same party rel combination.');
3019: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PARTY_REL_COMB');
3020: FND_MESSAGE.SET_TOKEN('PARTY_REL_COMB',to_char(l_alt_pk_instance_id) ||','||l_alt_pk_pty_source_tab||','||to_char(l_alt_pk_party_id)||','||l_alt_pk_rel_type_code||','||to_char(p_party_rec.contact_ip_id));
3021: FND_MSG_PUB.Add;
3022: RAISE FND_API.G_EXC_ERROR;
3023: WHEN OTHERS THEN

Line 3020: FND_MESSAGE.SET_TOKEN('PARTY_REL_COMB',to_char(l_alt_pk_instance_id) ||','||l_alt_pk_pty_source_tab||','||to_char(l_alt_pk_party_id)||','||l_alt_pk_rel_type_code||','||to_char(p_party_rec.contact_ip_id));

3016: EXCEPTION
3017: WHEN TOO_MANY_ROWS THEN
3018: csi_gen_utility_pvt.put_line('Too many rows exist in csi_i_parties with the same party rel combination.');
3019: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PARTY_REL_COMB');
3020: FND_MESSAGE.SET_TOKEN('PARTY_REL_COMB',to_char(l_alt_pk_instance_id) ||','||l_alt_pk_pty_source_tab||','||to_char(l_alt_pk_party_id)||','||l_alt_pk_rel_type_code||','||to_char(p_party_rec.contact_ip_id));
3021: FND_MSG_PUB.Add;
3022: RAISE FND_API.G_EXC_ERROR;
3023: WHEN OTHERS THEN
3024: NULL;

Line 3067: fnd_message.set_name('CSI','CSI_PRIMARY_PTY_EXC');

3063: p_party_rec.preferred_flag='E') OR
3064: (p_party_rec.preferred_flag=fnd_api.g_miss_char AND nvl(l_curr_party_rec.preferred_flag,'N') = 'E' AND
3065: p_party_rec.primary_flag='Y')
3066: THEN
3067: fnd_message.set_name('CSI','CSI_PRIMARY_PTY_EXC');
3068: fnd_msg_pub.Add;
3069: RAISE fnd_api.g_exc_error;
3070: END IF;
3071: -- Possible values for preferred flag are

Line 3080: fnd_message.set_name('CSI','CSI_PREFERRED_VALUES');

3076: p_party_rec.preferred_flag=fnd_api.g_miss_char
3077: THEN
3078: NULL;
3079: ELSE
3080: fnd_message.set_name('CSI','CSI_PREFERRED_VALUES');
3081: fnd_message.set_token('PREFERRED_FLAG',p_party_rec.preferred_flag);
3082: fnd_msg_pub.Add;
3083: RAISE fnd_api.g_exc_error;
3084: END IF;

Line 3081: fnd_message.set_token('PREFERRED_FLAG',p_party_rec.preferred_flag);

3077: THEN
3078: NULL;
3079: ELSE
3080: fnd_message.set_name('CSI','CSI_PREFERRED_VALUES');
3081: fnd_message.set_token('PREFERRED_FLAG',p_party_rec.preferred_flag);
3082: fnd_msg_pub.Add;
3083: RAISE fnd_api.g_exc_error;
3084: END IF;
3085: -- Call table handlers to update the table

Line 3157: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_FULL_DUMP_FAILED');

3153: --
3154: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
3155: --
3156: IF l_full_dump_frequency IS NULL THEN
3157: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_FULL_DUMP_FAILED');
3158: FND_MSG_PUB.ADD;
3159: RAISE FND_API.G_EXC_ERROR;
3160: END IF;
3161: -- Generate a unique instance_party_history_id from the sequence

Line 4388: -- FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_PARTY_ID');

4384: )
4385: )
4386: THEN
4387: -- Message added in the validation routine since additional validation added for bug # 2477417.
4388: -- FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_PARTY_ID');
4389: -- FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',p_instance_party_rec.instance_party_id);
4390: -- FND_MSG_PUB.Add;
4391: RAISE FND_API.G_EXC_ERROR;
4392: END IF;

Line 4389: -- FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',p_instance_party_rec.instance_party_id);

4385: )
4386: THEN
4387: -- Message added in the validation routine since additional validation added for bug # 2477417.
4388: -- FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_PARTY_ID');
4389: -- FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',p_instance_party_rec.instance_party_id);
4390: -- FND_MSG_PUB.Add;
4391: RAISE FND_API.G_EXC_ERROR;
4392: END IF;
4393: -- check if the object_version_number passed matches with the one

Line 4398: FND_MESSAGE.Set_Name('CSI', 'CSI_API_OBJ_VER_MISMATCH');

4394: -- in the database else raise error
4395: OPEN get_curr_party_rec(p_instance_party_rec.instance_party_id);
4396: FETCH get_curr_party_rec INTO l_curr_party_rec;
4397: IF (l_curr_party_rec.object_version_number <> p_instance_party_rec.OBJECT_VERSION_NUMBER) THEN
4398: FND_MESSAGE.Set_Name('CSI', 'CSI_API_OBJ_VER_MISMATCH');
4399: FND_MSG_PUB.ADD;
4400: RAISE FND_API.G_EXC_ERROR;
4401: END IF;
4402: --

Line 4404: FND_MESSAGE.Set_Name('CSI', 'CSI_API_RECORD_LOCKED');

4400: RAISE FND_API.G_EXC_ERROR;
4401: END IF;
4402: --
4403: IF get_curr_party_rec%NOTFOUND THEN
4404: FND_MESSAGE.Set_Name('CSI', 'CSI_API_RECORD_LOCKED');
4405: FND_MSG_PUB.ADD;
4406: RAISE FND_API.G_EXC_ERROR;
4407: END IF;
4408: CLOSE get_curr_party_rec;

Line 4822: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_PARTY_ID');

4818: END IF;
4819: END LOOP;
4820: --
4821: IF l_valid_flag <> 'Y' THEN
4822: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_PARTY_ID');
4823: FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',p_party_account_rec.INSTANCE_PARTY_ID);
4824: FND_MSG_PUB.Add;
4825: RAISE FND_API.G_EXC_ERROR;
4826: END IF;

Line 4823: FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',p_party_account_rec.INSTANCE_PARTY_ID);

4819: END LOOP;
4820: --
4821: IF l_valid_flag <> 'Y' THEN
4822: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_PARTY_ID');
4823: FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',p_party_account_rec.INSTANCE_PARTY_ID);
4824: FND_MSG_PUB.Add;
4825: RAISE FND_API.G_EXC_ERROR;
4826: END IF;
4827: END IF;

Line 4840: -- FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_PARTY_ID');

4836: )
4837: THEN
4838: p_inst_party_tbl(p_account_count_rec.inst_party_count).valid_flag := 'N';
4839: -- Message added in the validation routine since additional validation added for bug # 2477417.
4840: -- FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_PARTY_ID');
4841: -- FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',p_party_account_rec.INSTANCE_PARTY_ID);
4842: -- FND_MSG_PUB.Add;
4843: -- RAISE FND_API.G_EXC_ERROR;
4844: ELSE

Line 4841: -- FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',p_party_account_rec.INSTANCE_PARTY_ID);

4837: THEN
4838: p_inst_party_tbl(p_account_count_rec.inst_party_count).valid_flag := 'N';
4839: -- Message added in the validation routine since additional validation added for bug # 2477417.
4840: -- FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_PARTY_ID');
4841: -- FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',p_party_account_rec.INSTANCE_PARTY_ID);
4842: -- FND_MSG_PUB.Add;
4843: -- RAISE FND_API.G_EXC_ERROR;
4844: ELSE
4845: p_inst_party_tbl(p_account_count_rec.inst_party_count).valid_flag := 'Y';

Line 4877: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ACCOUNT_TYPE');

4873: END IF;
4874: END LOOP;
4875: --
4876: IF l_valid_flag <> 'Y' THEN
4877: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ACCOUNT_TYPE');
4878: FND_MESSAGE.SET_TOKEN('IP_RELATIONSHIP_TYPE_CODE',p_party_account_rec.RELATIONSHIP_TYPE_CODE);
4879: FND_MSG_PUB.Add;
4880: RAISE FND_API.G_EXC_ERROR;
4881: END IF;

Line 4878: FND_MESSAGE.SET_TOKEN('IP_RELATIONSHIP_TYPE_CODE',p_party_account_rec.RELATIONSHIP_TYPE_CODE);

4874: END LOOP;
4875: --
4876: IF l_valid_flag <> 'Y' THEN
4877: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ACCOUNT_TYPE');
4878: FND_MESSAGE.SET_TOKEN('IP_RELATIONSHIP_TYPE_CODE',p_party_account_rec.RELATIONSHIP_TYPE_CODE);
4879: FND_MSG_PUB.Add;
4880: RAISE FND_API.G_EXC_ERROR;
4881: END IF;
4882: END IF;

Line 4943: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_BILL_TO_ADD_ID');

4939: END IF;
4940: END LOOP;
4941: --
4942: IF l_valid_flag <> 'Y' THEN
4943: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_BILL_TO_ADD_ID');
4944: FND_MESSAGE.SET_TOKEN('BILL_TO_ADD_ID',p_party_account_rec.bill_to_address);
4945: FND_MSG_PUB.Add;
4946: RAISE FND_API.G_EXC_ERROR;
4947: END IF;

Line 4944: FND_MESSAGE.SET_TOKEN('BILL_TO_ADD_ID',p_party_account_rec.bill_to_address);

4940: END LOOP;
4941: --
4942: IF l_valid_flag <> 'Y' THEN
4943: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_BILL_TO_ADD_ID');
4944: FND_MESSAGE.SET_TOKEN('BILL_TO_ADD_ID',p_party_account_rec.bill_to_address);
4945: FND_MSG_PUB.Add;
4946: RAISE FND_API.G_EXC_ERROR;
4947: END IF;
4948: END IF;

Line 4983: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_SHIP_TO_ADD_ID');

4979: END IF;
4980: END LOOP;
4981: --
4982: IF l_valid_flag <> 'Y' THEN
4983: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_SHIP_TO_ADD_ID');
4984: FND_MESSAGE.SET_TOKEN('SHIP_TO_ADD_ID',p_party_account_rec.ship_to_address);
4985: FND_MSG_PUB.Add;
4986: RAISE FND_API.G_EXC_ERROR;
4987: END IF;

Line 4984: FND_MESSAGE.SET_TOKEN('SHIP_TO_ADD_ID',p_party_account_rec.ship_to_address);

4980: END LOOP;
4981: --
4982: IF l_valid_flag <> 'Y' THEN
4983: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_SHIP_TO_ADD_ID');
4984: FND_MESSAGE.SET_TOKEN('SHIP_TO_ADD_ID',p_party_account_rec.ship_to_address);
4985: FND_MSG_PUB.Add;
4986: RAISE FND_API.G_EXC_ERROR;
4987: END IF;
4988: END IF;

Line 5474: FND_MESSAGE.SET_NAME('CSI','CSI_API_MANDATORY_ACCOUNT');

5470: ' p_party_account_rec.IP_ACCOUNT_ID ',
5471: l_api_name );
5472: --
5473: IF p_party_account_rec.party_account_id IS NULL THEN
5474: FND_MESSAGE.SET_NAME('CSI','CSI_API_MANDATORY_ACCOUNT');
5475: FND_MSG_PUB.Add;
5476: RAISE FND_API.G_EXC_ERROR;
5477: END IF;
5478: --

Line 5488: FND_MESSAGE.Set_Name('CSI', 'CSI_API_OBJ_VER_MISMATCH');

5484: -- in the database else raise error
5485: OPEN get_curr_party_acct_rec(p_party_account_rec.IP_ACCOUNT_ID);
5486: FETCH get_curr_party_acct_rec INTO l_curr_party_acct_rec;
5487: IF (l_curr_party_acct_rec.object_version_number <> p_party_account_rec.OBJECT_VERSION_NUMBER) THEN
5488: FND_MESSAGE.Set_Name('CSI', 'CSI_API_OBJ_VER_MISMATCH');
5489: FND_MSG_PUB.ADD;
5490: RAISE FND_API.G_EXC_ERROR;
5491: END IF;
5492: IF get_curr_party_acct_rec%NOTFOUND THEN

Line 5493: FND_MESSAGE.Set_Name('CSI', 'CSI_API_RECORD_LOCKED');

5489: FND_MSG_PUB.ADD;
5490: RAISE FND_API.G_EXC_ERROR;
5491: END IF;
5492: IF get_curr_party_acct_rec%NOTFOUND THEN
5493: FND_MESSAGE.Set_Name('CSI', 'CSI_API_RECORD_LOCKED');
5494: FND_MSG_PUB.ADD;
5495: RAISE FND_API.G_EXC_ERROR;
5496: END IF;
5497: CLOSE get_curr_party_acct_rec;

Line 5519: -- FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_PARTY_ID');

5515: )
5516: )
5517: THEN
5518: -- Message added in the validation routine since additional validation added for bug # 2477417.
5519: -- FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_PARTY_ID');
5520: -- FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',p_party_account_rec.INSTANCE_PARTY_ID);
5521: -- FND_MSG_PUB.Add;
5522: RAISE FND_API.G_EXC_ERROR;
5523: END IF;

Line 5520: -- FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',p_party_account_rec.INSTANCE_PARTY_ID);

5516: )
5517: THEN
5518: -- Message added in the validation routine since additional validation added for bug # 2477417.
5519: -- FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_PARTY_ID');
5520: -- FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',p_party_account_rec.INSTANCE_PARTY_ID);
5521: -- FND_MSG_PUB.Add;
5522: RAISE FND_API.G_EXC_ERROR;
5523: END IF;
5524: IF p_party_account_rec.INSTANCE_PARTY_ID <> l_curr_party_acct_rec.INSTANCE_PARTY_ID THEN

Line 5528: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');

5524: IF p_party_account_rec.INSTANCE_PARTY_ID <> l_curr_party_acct_rec.INSTANCE_PARTY_ID THEN
5525: -- Start addition
5526: IF p_txn_rec.transaction_type_id <> 7
5527: THEN
5528: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
5529: FND_MESSAGE.Set_Token('COLUMN', 'INSTANCE_PARTY_ID');
5530: FND_MSG_PUB.ADD;
5531: RAISE FND_API.G_EXC_ERROR;
5532: ELSE

Line 5529: FND_MESSAGE.Set_Token('COLUMN', 'INSTANCE_PARTY_ID');

5525: -- Start addition
5526: IF p_txn_rec.transaction_type_id <> 7
5527: THEN
5528: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
5529: FND_MESSAGE.Set_Token('COLUMN', 'INSTANCE_PARTY_ID');
5530: FND_MSG_PUB.ADD;
5531: RAISE FND_API.G_EXC_ERROR;
5532: ELSE
5533: BEGIN

Line 5547: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');

5543: (p_party_account_rec.active_end_date = fnd_api.g_miss_date OR
5544: p_party_account_rec.active_end_date < SYSDATE )) */
5545: -- Commented the above code for bug 3539990 (reported in 11.5.9)
5546: THEN
5547: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
5548: FND_MESSAGE.Set_Token('COLUMN', 'INSTANCE_PARTY_ID');
5549: FND_MSG_PUB.ADD;
5550: RAISE FND_API.G_EXC_ERROR;
5551: END IF;

Line 5548: FND_MESSAGE.Set_Token('COLUMN', 'INSTANCE_PARTY_ID');

5544: p_party_account_rec.active_end_date < SYSDATE )) */
5545: -- Commented the above code for bug 3539990 (reported in 11.5.9)
5546: THEN
5547: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
5548: FND_MESSAGE.Set_Token('COLUMN', 'INSTANCE_PARTY_ID');
5549: FND_MSG_PUB.ADD;
5550: RAISE FND_API.G_EXC_ERROR;
5551: END IF;
5552: EXCEPTION

Line 5576: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');

5572: l_party_relation := CSI_Instance_parties_vld_pvt.Get_Party_relation
5573: (l_curr_party_acct_rec.Instance_party_id);
5574: --
5575: IF p_party_account_rec.active_start_date IS NULL THEN
5576: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
5577: FND_MESSAGE.Set_Token('COLUMN', 'ACTIVE_START_DATE');
5578: FND_MSG_PUB.ADD;
5579: RAISE FND_API.G_EXC_ERROR;
5580: END IF;

Line 5577: FND_MESSAGE.Set_Token('COLUMN', 'ACTIVE_START_DATE');

5573: (l_curr_party_acct_rec.Instance_party_id);
5574: --
5575: IF p_party_account_rec.active_start_date IS NULL THEN
5576: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
5577: FND_MESSAGE.Set_Token('COLUMN', 'ACTIVE_START_DATE');
5578: FND_MSG_PUB.ADD;
5579: RAISE FND_API.G_EXC_ERROR;
5580: END IF;
5581: --

Line 5584: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');

5580: END IF;
5581: --
5582: IF p_party_account_rec.active_start_date <> FND_API.G_MISS_DATE THEN
5583: IF p_party_account_rec.active_start_date <> l_curr_party_acct_rec.active_start_date THEN
5584: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
5585: FND_MESSAGE.Set_Token('COLUMN', 'ACTIVE_START_DATE');
5586: FND_MSG_PUB.ADD;
5587: RAISE FND_API.G_EXC_ERROR;
5588: END IF;

Line 5585: FND_MESSAGE.Set_Token('COLUMN', 'ACTIVE_START_DATE');

5581: --
5582: IF p_party_account_rec.active_start_date <> FND_API.G_MISS_DATE THEN
5583: IF p_party_account_rec.active_start_date <> l_curr_party_acct_rec.active_start_date THEN
5584: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
5585: FND_MESSAGE.Set_Token('COLUMN', 'ACTIVE_START_DATE');
5586: FND_MSG_PUB.ADD;
5587: RAISE FND_API.G_EXC_ERROR;
5588: END IF;
5589: END IF;

Line 5604: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');

5600: --
5601: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
5602: --
5603: IF l_internal_party_id IS NULL THEN
5604: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
5605: FND_MSG_PUB.ADD;
5606: RAISE FND_API.G_EXC_ERROR;
5607: END IF;
5608: --

Line 5613: FND_MESSAGE.Set_Name('CSI', 'CSI_API_EXP_NOT_ALLOWED');

5609: -- End addition by sguthiva for bug 2307804
5610: IF p_party_account_rec.expire_flag = fnd_api.g_false -- Added by sguthiva for bug 2307804
5611: -- IF csi_party_relationships_pvt.g_force_expire_flag = 'N' -- Commented by sguthiva for bug 2307804
5612: THEN
5613: FND_MESSAGE.Set_Name('CSI', 'CSI_API_EXP_NOT_ALLOWED');
5614: FND_MESSAGE.Set_Token('COLUMN', 'OWNER ACCOUNT');
5615: FND_MSG_PUB.ADD;
5616: RAISE FND_API.G_EXC_ERROR;
5617: END IF;

Line 5614: FND_MESSAGE.Set_Token('COLUMN', 'OWNER ACCOUNT');

5610: IF p_party_account_rec.expire_flag = fnd_api.g_false -- Added by sguthiva for bug 2307804
5611: -- IF csi_party_relationships_pvt.g_force_expire_flag = 'N' -- Commented by sguthiva for bug 2307804
5612: THEN
5613: FND_MESSAGE.Set_Name('CSI', 'CSI_API_EXP_NOT_ALLOWED');
5614: FND_MESSAGE.Set_Token('COLUMN', 'OWNER ACCOUNT');
5615: FND_MSG_PUB.ADD;
5616: RAISE FND_API.G_EXC_ERROR;
5617: END IF;
5618: ELSE

Line 5639: FND_MESSAGE.Set_Name('CSI', 'CSI_ENDDT_GT_STDT');

5635: p_party_account_rec.ACTIVE_END_DATE <> FND_API.G_MISS_DATE AND l_curr_party_acct_rec.ACTIVE_START_DATE IS NOT NULL AND
5636: l_curr_party_acct_rec.ACTIVE_START_DATE <> FND_API.G_MISS_DATE AND
5637: p_party_account_rec.ACTIVE_END_DATE < l_curr_party_acct_rec.ACTIVE_START_DATE
5638: THEN
5639: FND_MESSAGE.Set_Name('CSI', 'CSI_ENDDT_GT_STDT');
5640:
5641: FND_MESSAGE.Set_Token('END_DATE',p_party_account_rec.ACTIVE_END_DATE);
5642: FND_MESSAGE.Set_Token('START_DATE',l_curr_party_acct_rec.ACTIVE_START_DATE);
5643: FND_MSG_PUB.ADD;

Line 5641: FND_MESSAGE.Set_Token('END_DATE',p_party_account_rec.ACTIVE_END_DATE);

5637: p_party_account_rec.ACTIVE_END_DATE < l_curr_party_acct_rec.ACTIVE_START_DATE
5638: THEN
5639: FND_MESSAGE.Set_Name('CSI', 'CSI_ENDDT_GT_STDT');
5640:
5641: FND_MESSAGE.Set_Token('END_DATE',p_party_account_rec.ACTIVE_END_DATE);
5642: FND_MESSAGE.Set_Token('START_DATE',l_curr_party_acct_rec.ACTIVE_START_DATE);
5643: FND_MSG_PUB.ADD;
5644: RAISE FND_API.G_EXC_ERROR;
5645: END IF;

Line 5642: FND_MESSAGE.Set_Token('START_DATE',l_curr_party_acct_rec.ACTIVE_START_DATE);

5638: THEN
5639: FND_MESSAGE.Set_Name('CSI', 'CSI_ENDDT_GT_STDT');
5640:
5641: FND_MESSAGE.Set_Token('END_DATE',p_party_account_rec.ACTIVE_END_DATE);
5642: FND_MESSAGE.Set_Token('START_DATE',l_curr_party_acct_rec.ACTIVE_START_DATE);
5643: FND_MSG_PUB.ADD;
5644: RAISE FND_API.G_EXC_ERROR;
5645: END IF;
5646: -- End code addition for bug 3855525.

Line 5659: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');

5655: IF p_party_account_rec.relationship_type_code <> FND_API.G_MISS_CHAR THEN
5656: IF ((p_party_account_rec.relationship_type_code <> l_curr_party_acct_rec.relationship_type_code)
5657: AND (l_curr_party_acct_rec.relationship_type_code = 'OWNER')
5658: AND (l_party_relation = 'OWNER')) THEN
5659: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
5660: FND_MESSAGE.Set_Token('COLUMN', 'OWNER ACCOUNT');
5661: FND_MSG_PUB.ADD;
5662: RAISE FND_API.G_EXC_ERROR;
5663: ELSE

Line 5660: FND_MESSAGE.Set_Token('COLUMN', 'OWNER ACCOUNT');

5656: IF ((p_party_account_rec.relationship_type_code <> l_curr_party_acct_rec.relationship_type_code)
5657: AND (l_curr_party_acct_rec.relationship_type_code = 'OWNER')
5658: AND (l_party_relation = 'OWNER')) THEN
5659: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
5660: FND_MESSAGE.Set_Token('COLUMN', 'OWNER ACCOUNT');
5661: FND_MSG_PUB.ADD;
5662: RAISE FND_API.G_EXC_ERROR;
5663: ELSE
5664: -- Verify the relationship_type_code is valid

Line 5926: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_FULL_DUMP_FAILED');

5922: --
5923: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
5924: --
5925: IF l_full_dump_frequency IS NULL THEN
5926: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_FULL_DUMP_FAILED');
5927: FND_MSG_PUB.ADD;
5928: RAISE FND_API.G_EXC_ERROR;
5929: END IF;
5930: --

Line 6883: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');

6879: --
6880: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
6881: --
6882: IF l_internal_party_id IS NULL THEN
6883: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
6884: FND_MSG_PUB.ADD;
6885: RAISE FND_API.G_EXC_ERROR;
6886: END IF;
6887: -- Commenting as we are not using this code

Line 7243: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_IP_ACCOUNT_ID');

7239:
7240: -- Check if the instance party id is valid
7241: IF NOT(CSI_Instance_parties_vld_pvt.Is_Ip_account_Valid
7242: (p_party_account_rec.ip_account_id))THEN
7243: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_IP_ACCOUNT_ID');
7244: FND_MESSAGE.SET_TOKEN('IP_ACCOUNT_ID',p_party_account_rec.ip_account_id);
7245: FND_MSG_PUB.Add;
7246: RAISE FND_API.G_EXC_ERROR;
7247: END IF;

Line 7244: FND_MESSAGE.SET_TOKEN('IP_ACCOUNT_ID',p_party_account_rec.ip_account_id);

7240: -- Check if the instance party id is valid
7241: IF NOT(CSI_Instance_parties_vld_pvt.Is_Ip_account_Valid
7242: (p_party_account_rec.ip_account_id))THEN
7243: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_IP_ACCOUNT_ID');
7244: FND_MESSAGE.SET_TOKEN('IP_ACCOUNT_ID',p_party_account_rec.ip_account_id);
7245: FND_MSG_PUB.Add;
7246: RAISE FND_API.G_EXC_ERROR;
7247: END IF;
7248: -- check if the object_version_number passed matches with the one

Line 7254: FND_MESSAGE.Set_Name('CSI', 'CSI_API_OBJ_VER_MISMATCH');

7250: OPEN get_curr_party_acct_rec(p_party_account_rec.ip_account_id);
7251: FETCH get_curr_party_acct_rec INTO l_curr_party_acct_rec;
7252:
7253: IF (l_curr_party_acct_rec.object_version_number <> p_party_account_rec.OBJECT_VERSION_NUMBER) THEN
7254: FND_MESSAGE.Set_Name('CSI', 'CSI_API_OBJ_VER_MISMATCH');
7255: FND_MSG_PUB.ADD;
7256: RAISE FND_API.G_EXC_ERROR;
7257: END IF;
7258: --

Line 7260: FND_MESSAGE.Set_Name('CSI', 'CSI_API_RECORD_LOCKED');

7256: RAISE FND_API.G_EXC_ERROR;
7257: END IF;
7258: --
7259: IF get_curr_party_acct_rec%NOTFOUND THEN
7260: FND_MESSAGE.Set_Name('CSI', 'CSI_API_RECORD_LOCKED');
7261: FND_MSG_PUB.ADD;
7262: RAISE FND_API.G_EXC_ERROR;
7263: END IF;
7264: CLOSE get_curr_party_acct_rec;

Line 7431: fnd_message.set_name('CSI', 'CSI_API_INVALID_PARAMETERS');

7427: IF ( ( p_contact_party_id IS NULL OR p_contact_party_id = fnd_api.g_miss_num )
7428: OR ( p_party_tbl IS NULL OR p_party_tbl = fnd_api.g_miss_char )
7429: )
7430: THEN
7431: fnd_message.set_name('CSI', 'CSI_API_INVALID_PARAMETERS');
7432: fnd_msg_pub.add;
7433: x_return_status := fnd_api.g_ret_sts_error;
7434: RAISE fnd_api.g_exc_error;
7435: END IF;

Line 8474: --FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_TXN_ID');

8470:
8471: -- End addition for bug 2179142
8472: i := i + 1;
8473: --IF get_party_hist%NOTFOUND THEN
8474: --FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_TXN_ID');
8475: --FND_MSG_PUB.Add;
8476: --RAISE FND_API.G_EXC_ERROR;
8477: --END IF;
8478: END LOOP;