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 2611: FND_MESSAGE.SET_NAME('CSI','CSI_API_MANDATORY_PARTY');

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

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

2686: -- in the database else raise error
2687: OPEN get_curr_party_rec(p_party_rec.INSTANCE_PARTY_ID);
2688: FETCH get_curr_party_rec INTO l_curr_party_rec;
2689: IF (l_curr_party_rec.object_version_number <> p_party_rec.OBJECT_VERSION_NUMBER) THEN
2690: FND_MESSAGE.Set_Name('CSI', 'CSI_API_OBJ_VER_MISMATCH');
2691: FND_MSG_PUB.ADD;
2692: RAISE FND_API.G_EXC_ERROR;
2693: END IF;
2694: --

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

2692: RAISE FND_API.G_EXC_ERROR;
2693: END IF;
2694: --
2695: IF get_curr_party_rec%NOTFOUND THEN
2696: FND_MESSAGE.Set_Name('CSI', 'CSI_API_RECORD_LOCKED');
2697: FND_MSG_PUB.ADD;
2698: RAISE FND_API.G_EXC_ERROR;
2699: END IF;
2700: CLOSE get_curr_party_rec;

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

2700: CLOSE get_curr_party_rec;
2701: --
2702: IF p_party_rec.instance_id <> FND_API.G_MISS_NUM THEN
2703: IF p_party_rec.instance_id <> l_curr_party_rec.instance_id THEN
2704: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
2705: FND_MESSAGE.Set_Token('COLUMN', 'INSTANCE_ID');
2706: FND_MSG_PUB.ADD;
2707: RAISE FND_API.G_EXC_ERROR;
2708: END IF;

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

2701: --
2702: IF p_party_rec.instance_id <> FND_API.G_MISS_NUM THEN
2703: IF p_party_rec.instance_id <> l_curr_party_rec.instance_id THEN
2704: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
2705: FND_MESSAGE.Set_Token('COLUMN', 'INSTANCE_ID');
2706: FND_MSG_PUB.ADD;
2707: RAISE FND_API.G_EXC_ERROR;
2708: END IF;
2709: END IF;

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

2708: END IF;
2709: END IF;
2710: --
2711: IF p_party_rec.active_start_date IS NULL THEN
2712: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
2713: FND_MESSAGE.Set_Token('COLUMN', 'ACTIVE_START_DATE');
2714: FND_MSG_PUB.ADD;
2715: RAISE FND_API.G_EXC_ERROR;
2716: END IF;

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

2709: END IF;
2710: --
2711: IF p_party_rec.active_start_date IS NULL THEN
2712: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
2713: FND_MESSAGE.Set_Token('COLUMN', 'ACTIVE_START_DATE');
2714: FND_MSG_PUB.ADD;
2715: RAISE FND_API.G_EXC_ERROR;
2716: END IF;
2717: --

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

2716: END IF;
2717: --
2718: IF p_party_rec.active_start_date <> FND_API.G_MISS_DATE THEN
2719: IF p_party_rec.active_start_date <> l_curr_party_rec.active_start_date THEN
2720: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
2721: FND_MESSAGE.Set_Token('COLUMN', 'ACTIVE_START_DATE');
2722: FND_MSG_PUB.ADD;
2723: RAISE FND_API.G_EXC_ERROR;
2724: END IF;

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

2717: --
2718: IF p_party_rec.active_start_date <> FND_API.G_MISS_DATE THEN
2719: IF p_party_rec.active_start_date <> l_curr_party_rec.active_start_date THEN
2720: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
2721: FND_MESSAGE.Set_Token('COLUMN', 'ACTIVE_START_DATE');
2722: FND_MSG_PUB.ADD;
2723: RAISE FND_API.G_EXC_ERROR;
2724: END IF;
2725: END IF;

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

2728: -- Verify if the active_end_date is valid
2729: -- Don't allow expiry of owner parties
2730: IF p_party_rec.ACTIVE_END_DATE <> FND_API.G_MISS_DATE THEN
2731: IF l_curr_party_rec.relationship_type_code = 'OWNER' THEN
2732: FND_MESSAGE.Set_Name('CSI', 'CSI_API_EXP_NOT_ALLOWED');
2733: FND_MESSAGE.Set_Token('COLUMN', 'OWNER PARTY');
2734: FND_MSG_PUB.ADD;
2735: RAISE FND_API.G_EXC_ERROR;
2736: ELSE

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

2729: -- Don't allow expiry of owner parties
2730: IF p_party_rec.ACTIVE_END_DATE <> FND_API.G_MISS_DATE THEN
2731: IF l_curr_party_rec.relationship_type_code = 'OWNER' THEN
2732: FND_MESSAGE.Set_Name('CSI', 'CSI_API_EXP_NOT_ALLOWED');
2733: FND_MESSAGE.Set_Token('COLUMN', 'OWNER PARTY');
2734: FND_MSG_PUB.ADD;
2735: RAISE FND_API.G_EXC_ERROR;
2736: ELSE
2737: -- Verify if the active_end_date is valid

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

2750: --
2751: IF p_party_rec.relationship_type_code <> FND_API.G_MISS_CHAR THEN
2752: IF ((p_party_rec.relationship_type_code <> l_curr_party_rec.relationship_type_code)
2753: AND l_curr_party_rec.relationship_type_code = 'OWNER' ) THEN
2754: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
2755: FND_MESSAGE.Set_Token('COLUMN', 'OWNER PARTY');
2756:
2757: FND_MSG_PUB.ADD;
2758: RAISE FND_API.G_EXC_ERROR;

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

2751: IF p_party_rec.relationship_type_code <> FND_API.G_MISS_CHAR THEN
2752: IF ((p_party_rec.relationship_type_code <> l_curr_party_rec.relationship_type_code)
2753: AND l_curr_party_rec.relationship_type_code = 'OWNER' ) THEN
2754: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
2755: FND_MESSAGE.Set_Token('COLUMN', 'OWNER PARTY');
2756:
2757: FND_MSG_PUB.ADD;
2758: RAISE FND_API.G_EXC_ERROR;
2759: ELSE

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

2802: IF p_party_rec.CONTACT_FLAG <> 'Y' THEN
2803: IF (((p_party_rec.PARTY_SOURCE_TABLE <> FND_API.G_MISS_CHAR)
2804: AND (p_party_rec.PARTY_SOURCE_TABLE NOT IN ('GROUP','TEAM')))
2805: OR (l_curr_party_rec.PARTY_SOURCE_TABLE NOT IN ('GROUP','TEAM'))) THEN
2806: FND_MESSAGE.SET_NAME('CSI','CSI_PREFERRED_PTY_TYPE');
2807: FND_MESSAGE.SET_TOKEN('PARTY_TYPE',l_curr_party_rec.PARTY_SOURCE_TABLE);
2808: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_curr_party_rec.INSTANCE_ID);
2809: FND_MSG_PUB.Add;
2810: RAISE FND_API.G_EXC_ERROR;

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

2803: IF (((p_party_rec.PARTY_SOURCE_TABLE <> FND_API.G_MISS_CHAR)
2804: AND (p_party_rec.PARTY_SOURCE_TABLE NOT IN ('GROUP','TEAM')))
2805: OR (l_curr_party_rec.PARTY_SOURCE_TABLE NOT IN ('GROUP','TEAM'))) THEN
2806: FND_MESSAGE.SET_NAME('CSI','CSI_PREFERRED_PTY_TYPE');
2807: FND_MESSAGE.SET_TOKEN('PARTY_TYPE',l_curr_party_rec.PARTY_SOURCE_TABLE);
2808: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_curr_party_rec.INSTANCE_ID);
2809: FND_MSG_PUB.Add;
2810: RAISE FND_API.G_EXC_ERROR;
2811: END IF;

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

2804: AND (p_party_rec.PARTY_SOURCE_TABLE NOT IN ('GROUP','TEAM')))
2805: OR (l_curr_party_rec.PARTY_SOURCE_TABLE NOT IN ('GROUP','TEAM'))) THEN
2806: FND_MESSAGE.SET_NAME('CSI','CSI_PREFERRED_PTY_TYPE');
2807: FND_MESSAGE.SET_TOKEN('PARTY_TYPE',l_curr_party_rec.PARTY_SOURCE_TABLE);
2808: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_curr_party_rec.INSTANCE_ID);
2809: FND_MSG_PUB.Add;
2810: RAISE FND_API.G_EXC_ERROR;
2811: END IF;
2812: END IF;

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

2865: IF (((p_party_rec.PARTY_SOURCE_TABLE <> FND_API.G_MISS_CHAR)
2866: AND (p_party_rec.PARTY_SOURCE_TABLE NOT IN ('GROUP','TEAM')))
2867: OR (l_curr_party_rec.PARTY_SOURCE_TABLE NOT IN ('GROUP','TEAM'))) THEN
2868: -- following code is commented by sk
2869: /*FND_MESSAGE.SET_NAME('CSI','CSI_HAHA2');
2870: --FND_MESSAGE.SET_NAME('CSI','CSI_PRIMARY_PTY_TYPE');
2871: FND_MESSAGE.SET_TOKEN('PARTY_TYPE',l_curr_party_rec.PARTY_SOURCE_TABLE);
2872: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_curr_party_rec.INSTANCE_ID);
2873: FND_MSG_PUB.Add;

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

2866: AND (p_party_rec.PARTY_SOURCE_TABLE NOT IN ('GROUP','TEAM')))
2867: OR (l_curr_party_rec.PARTY_SOURCE_TABLE NOT IN ('GROUP','TEAM'))) THEN
2868: -- following code is commented by sk
2869: /*FND_MESSAGE.SET_NAME('CSI','CSI_HAHA2');
2870: --FND_MESSAGE.SET_NAME('CSI','CSI_PRIMARY_PTY_TYPE');
2871: FND_MESSAGE.SET_TOKEN('PARTY_TYPE',l_curr_party_rec.PARTY_SOURCE_TABLE);
2872: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_curr_party_rec.INSTANCE_ID);
2873: FND_MSG_PUB.Add;
2874: RAISE FND_API.G_EXC_ERROR; */

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

2867: OR (l_curr_party_rec.PARTY_SOURCE_TABLE NOT IN ('GROUP','TEAM'))) THEN
2868: -- following code is commented by sk
2869: /*FND_MESSAGE.SET_NAME('CSI','CSI_HAHA2');
2870: --FND_MESSAGE.SET_NAME('CSI','CSI_PRIMARY_PTY_TYPE');
2871: FND_MESSAGE.SET_TOKEN('PARTY_TYPE',l_curr_party_rec.PARTY_SOURCE_TABLE);
2872: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_curr_party_rec.INSTANCE_ID);
2873: FND_MSG_PUB.Add;
2874: RAISE FND_API.G_EXC_ERROR; */
2875: NULL; --added by sk

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

2868: -- following code is commented by sk
2869: /*FND_MESSAGE.SET_NAME('CSI','CSI_HAHA2');
2870: --FND_MESSAGE.SET_NAME('CSI','CSI_PRIMARY_PTY_TYPE');
2871: FND_MESSAGE.SET_TOKEN('PARTY_TYPE',l_curr_party_rec.PARTY_SOURCE_TABLE);
2872: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_curr_party_rec.INSTANCE_ID);
2873: FND_MSG_PUB.Add;
2874: RAISE FND_API.G_EXC_ERROR; */
2875: NULL; --added by sk
2876: ELSE

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

2941: --
2942: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
2943: --
2944: IF l_internal_party_id IS NULL THEN
2945: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
2946: FND_MSG_PUB.ADD;
2947: RAISE FND_API.G_EXC_ERROR;
2948: END IF;
2949: -- Validate Tranfer Party rules in case of tranfer of instance

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

3054: END;
3055: EXCEPTION
3056: WHEN TOO_MANY_ROWS THEN
3057: csi_gen_utility_pvt.put_line('Too many rows exist in csi_i_parties with the same party rel combination.');
3058: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PARTY_REL_COMB');
3059: 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));
3060: FND_MSG_PUB.Add;
3061: RAISE FND_API.G_EXC_ERROR;
3062: WHEN OTHERS THEN

Line 3059: 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));

3055: EXCEPTION
3056: WHEN TOO_MANY_ROWS THEN
3057: csi_gen_utility_pvt.put_line('Too many rows exist in csi_i_parties with the same party rel combination.');
3058: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PARTY_REL_COMB');
3059: 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));
3060: FND_MSG_PUB.Add;
3061: RAISE FND_API.G_EXC_ERROR;
3062: WHEN OTHERS THEN
3063: NULL;

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

3102: p_party_rec.preferred_flag='E') OR
3103: (p_party_rec.preferred_flag=fnd_api.g_miss_char AND nvl(l_curr_party_rec.preferred_flag,'N') = 'E' AND
3104: p_party_rec.primary_flag='Y')
3105: THEN
3106: fnd_message.set_name('CSI','CSI_PRIMARY_PTY_EXC');
3107: fnd_msg_pub.Add;
3108: RAISE fnd_api.g_exc_error;
3109: END IF;
3110: -- Possible values for preferred flag are

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

3115: p_party_rec.preferred_flag=fnd_api.g_miss_char
3116: THEN
3117: NULL;
3118: ELSE
3119: fnd_message.set_name('CSI','CSI_PREFERRED_VALUES');
3120: fnd_message.set_token('PREFERRED_FLAG',p_party_rec.preferred_flag);
3121: fnd_msg_pub.Add;
3122: RAISE fnd_api.g_exc_error;
3123: END IF;

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

3116: THEN
3117: NULL;
3118: ELSE
3119: fnd_message.set_name('CSI','CSI_PREFERRED_VALUES');
3120: fnd_message.set_token('PREFERRED_FLAG',p_party_rec.preferred_flag);
3121: fnd_msg_pub.Add;
3122: RAISE fnd_api.g_exc_error;
3123: END IF;
3124: -- Call table handlers to update the table

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

3192: --
3193: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
3194: --
3195: IF l_full_dump_frequency IS NULL THEN
3196: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_FULL_DUMP_FAILED');
3197: FND_MSG_PUB.ADD;
3198: RAISE FND_API.G_EXC_ERROR;
3199: END IF;
3200: -- Generate a unique instance_party_history_id from the sequence

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

4423: )
4424: )
4425: THEN
4426: -- Message added in the validation routine since additional validation added for bug # 2477417.
4427: -- FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_PARTY_ID');
4428: -- FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',p_instance_party_rec.instance_party_id);
4429: -- FND_MSG_PUB.Add;
4430: RAISE FND_API.G_EXC_ERROR;
4431: END IF;

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

4424: )
4425: THEN
4426: -- Message added in the validation routine since additional validation added for bug # 2477417.
4427: -- FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_PARTY_ID');
4428: -- FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',p_instance_party_rec.instance_party_id);
4429: -- FND_MSG_PUB.Add;
4430: RAISE FND_API.G_EXC_ERROR;
4431: END IF;
4432: -- check if the object_version_number passed matches with the one

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

4433: -- in the database else raise error
4434: OPEN get_curr_party_rec(p_instance_party_rec.instance_party_id);
4435: FETCH get_curr_party_rec INTO l_curr_party_rec;
4436: IF (l_curr_party_rec.object_version_number <> p_instance_party_rec.OBJECT_VERSION_NUMBER) THEN
4437: FND_MESSAGE.Set_Name('CSI', 'CSI_API_OBJ_VER_MISMATCH');
4438: FND_MSG_PUB.ADD;
4439: RAISE FND_API.G_EXC_ERROR;
4440: END IF;
4441: --

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

4439: RAISE FND_API.G_EXC_ERROR;
4440: END IF;
4441: --
4442: IF get_curr_party_rec%NOTFOUND THEN
4443: FND_MESSAGE.Set_Name('CSI', 'CSI_API_RECORD_LOCKED');
4444: FND_MSG_PUB.ADD;
4445: RAISE FND_API.G_EXC_ERROR;
4446: END IF;
4447: CLOSE get_curr_party_rec;

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

4857: END IF;
4858: END LOOP;
4859: --
4860: IF l_valid_flag <> 'Y' THEN
4861: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_PARTY_ID');
4862: FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',p_party_account_rec.INSTANCE_PARTY_ID);
4863: FND_MSG_PUB.Add;
4864: RAISE FND_API.G_EXC_ERROR;
4865: END IF;

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

4858: END LOOP;
4859: --
4860: IF l_valid_flag <> 'Y' THEN
4861: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_PARTY_ID');
4862: FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',p_party_account_rec.INSTANCE_PARTY_ID);
4863: FND_MSG_PUB.Add;
4864: RAISE FND_API.G_EXC_ERROR;
4865: END IF;
4866: END IF;

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

4875: )
4876: THEN
4877: p_inst_party_tbl(p_account_count_rec.inst_party_count).valid_flag := 'N';
4878: -- Message added in the validation routine since additional validation added for bug # 2477417.
4879: -- FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_PARTY_ID');
4880: -- FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',p_party_account_rec.INSTANCE_PARTY_ID);
4881: -- FND_MSG_PUB.Add;
4882: -- RAISE FND_API.G_EXC_ERROR;
4883: ELSE

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

4876: THEN
4877: p_inst_party_tbl(p_account_count_rec.inst_party_count).valid_flag := 'N';
4878: -- Message added in the validation routine since additional validation added for bug # 2477417.
4879: -- FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_PARTY_ID');
4880: -- FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',p_party_account_rec.INSTANCE_PARTY_ID);
4881: -- FND_MSG_PUB.Add;
4882: -- RAISE FND_API.G_EXC_ERROR;
4883: ELSE
4884: p_inst_party_tbl(p_account_count_rec.inst_party_count).valid_flag := 'Y';

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

4912: END IF;
4913: END LOOP;
4914: --
4915: IF l_valid_flag <> 'Y' THEN
4916: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ACCOUNT_TYPE');
4917: FND_MESSAGE.SET_TOKEN('IP_RELATIONSHIP_TYPE_CODE',p_party_account_rec.RELATIONSHIP_TYPE_CODE);
4918: FND_MSG_PUB.Add;
4919: RAISE FND_API.G_EXC_ERROR;
4920: END IF;

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

4913: END LOOP;
4914: --
4915: IF l_valid_flag <> 'Y' THEN
4916: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ACCOUNT_TYPE');
4917: FND_MESSAGE.SET_TOKEN('IP_RELATIONSHIP_TYPE_CODE',p_party_account_rec.RELATIONSHIP_TYPE_CODE);
4918: FND_MSG_PUB.Add;
4919: RAISE FND_API.G_EXC_ERROR;
4920: END IF;
4921: END IF;

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

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

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

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

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

5018: END IF;
5019: END LOOP;
5020: --
5021: IF l_valid_flag <> 'Y' THEN
5022: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_SHIP_TO_ADD_ID');
5023: FND_MESSAGE.SET_TOKEN('SHIP_TO_ADD_ID',p_party_account_rec.ship_to_address);
5024: FND_MSG_PUB.Add;
5025: RAISE FND_API.G_EXC_ERROR;
5026: END IF;

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

5019: END LOOP;
5020: --
5021: IF l_valid_flag <> 'Y' THEN
5022: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_SHIP_TO_ADD_ID');
5023: FND_MESSAGE.SET_TOKEN('SHIP_TO_ADD_ID',p_party_account_rec.ship_to_address);
5024: FND_MSG_PUB.Add;
5025: RAISE FND_API.G_EXC_ERROR;
5026: END IF;
5027: END IF;

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

5511: ' p_party_account_rec.IP_ACCOUNT_ID ',
5512: l_api_name );
5513: --
5514: IF p_party_account_rec.party_account_id IS NULL THEN
5515: FND_MESSAGE.SET_NAME('CSI','CSI_API_MANDATORY_ACCOUNT');
5516: FND_MSG_PUB.Add;
5517: RAISE FND_API.G_EXC_ERROR;
5518: END IF;
5519: --

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

5525: -- in the database else raise error
5526: OPEN get_curr_party_acct_rec(p_party_account_rec.IP_ACCOUNT_ID);
5527: FETCH get_curr_party_acct_rec INTO l_curr_party_acct_rec;
5528: IF (l_curr_party_acct_rec.object_version_number <> p_party_account_rec.OBJECT_VERSION_NUMBER) THEN
5529: FND_MESSAGE.Set_Name('CSI', 'CSI_API_OBJ_VER_MISMATCH');
5530: FND_MSG_PUB.ADD;
5531: RAISE FND_API.G_EXC_ERROR;
5532: END IF;
5533: IF get_curr_party_acct_rec%NOTFOUND THEN

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

5530: FND_MSG_PUB.ADD;
5531: RAISE FND_API.G_EXC_ERROR;
5532: END IF;
5533: IF get_curr_party_acct_rec%NOTFOUND THEN
5534: FND_MESSAGE.Set_Name('CSI', 'CSI_API_RECORD_LOCKED');
5535: FND_MSG_PUB.ADD;
5536: RAISE FND_API.G_EXC_ERROR;
5537: END IF;
5538: CLOSE get_curr_party_acct_rec;

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

5556: )
5557: )
5558: THEN
5559: -- Message added in the validation routine since additional validation added for bug # 2477417.
5560: -- FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_PARTY_ID');
5561: -- FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',p_party_account_rec.INSTANCE_PARTY_ID);
5562: -- FND_MSG_PUB.Add;
5563: RAISE FND_API.G_EXC_ERROR;
5564: END IF;

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

5557: )
5558: THEN
5559: -- Message added in the validation routine since additional validation added for bug # 2477417.
5560: -- FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_PARTY_ID');
5561: -- FND_MESSAGE.SET_TOKEN('INSTANCE_PARTY_ID',p_party_account_rec.INSTANCE_PARTY_ID);
5562: -- FND_MSG_PUB.Add;
5563: RAISE FND_API.G_EXC_ERROR;
5564: END IF;
5565: IF p_party_account_rec.INSTANCE_PARTY_ID <> l_curr_party_acct_rec.INSTANCE_PARTY_ID THEN

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

5565: IF p_party_account_rec.INSTANCE_PARTY_ID <> l_curr_party_acct_rec.INSTANCE_PARTY_ID THEN
5566: -- Start addition
5567: IF p_txn_rec.transaction_type_id <> 7
5568: THEN
5569: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
5570: FND_MESSAGE.Set_Token('COLUMN', 'INSTANCE_PARTY_ID');
5571: FND_MSG_PUB.ADD;
5572: RAISE FND_API.G_EXC_ERROR;
5573: ELSE

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

5566: -- Start addition
5567: IF p_txn_rec.transaction_type_id <> 7
5568: THEN
5569: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
5570: FND_MESSAGE.Set_Token('COLUMN', 'INSTANCE_PARTY_ID');
5571: FND_MSG_PUB.ADD;
5572: RAISE FND_API.G_EXC_ERROR;
5573: ELSE
5574: BEGIN

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

5584: (p_party_account_rec.active_end_date = fnd_api.g_miss_date OR
5585: p_party_account_rec.active_end_date < SYSDATE )) */
5586: -- Commented the above code for bug 3539990 (reported in 11.5.9)
5587: THEN
5588: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
5589: FND_MESSAGE.Set_Token('COLUMN', 'INSTANCE_PARTY_ID');
5590: FND_MSG_PUB.ADD;
5591: RAISE FND_API.G_EXC_ERROR;
5592: END IF;

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

5585: p_party_account_rec.active_end_date < SYSDATE )) */
5586: -- Commented the above code for bug 3539990 (reported in 11.5.9)
5587: THEN
5588: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
5589: FND_MESSAGE.Set_Token('COLUMN', 'INSTANCE_PARTY_ID');
5590: FND_MSG_PUB.ADD;
5591: RAISE FND_API.G_EXC_ERROR;
5592: END IF;
5593: EXCEPTION

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

5613: l_party_relation := CSI_Instance_parties_vld_pvt.Get_Party_relation
5614: (l_curr_party_acct_rec.Instance_party_id);
5615: --
5616: IF p_party_account_rec.active_start_date IS NULL THEN
5617: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
5618: FND_MESSAGE.Set_Token('COLUMN', 'ACTIVE_START_DATE');
5619: FND_MSG_PUB.ADD;
5620: RAISE FND_API.G_EXC_ERROR;
5621: END IF;

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

5614: (l_curr_party_acct_rec.Instance_party_id);
5615: --
5616: IF p_party_account_rec.active_start_date IS NULL THEN
5617: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
5618: FND_MESSAGE.Set_Token('COLUMN', 'ACTIVE_START_DATE');
5619: FND_MSG_PUB.ADD;
5620: RAISE FND_API.G_EXC_ERROR;
5621: END IF;
5622: --

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

5621: END IF;
5622: --
5623: IF p_party_account_rec.active_start_date <> FND_API.G_MISS_DATE THEN
5624: IF p_party_account_rec.active_start_date <> l_curr_party_acct_rec.active_start_date THEN
5625: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
5626: FND_MESSAGE.Set_Token('COLUMN', 'ACTIVE_START_DATE');
5627: FND_MSG_PUB.ADD;
5628: RAISE FND_API.G_EXC_ERROR;
5629: END IF;

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

5622: --
5623: IF p_party_account_rec.active_start_date <> FND_API.G_MISS_DATE THEN
5624: IF p_party_account_rec.active_start_date <> l_curr_party_acct_rec.active_start_date THEN
5625: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
5626: FND_MESSAGE.Set_Token('COLUMN', 'ACTIVE_START_DATE');
5627: FND_MSG_PUB.ADD;
5628: RAISE FND_API.G_EXC_ERROR;
5629: END IF;
5630: END IF;

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

5641: --
5642: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
5643: --
5644: IF l_internal_party_id IS NULL THEN
5645: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
5646: FND_MSG_PUB.ADD;
5647: RAISE FND_API.G_EXC_ERROR;
5648: END IF;
5649: --

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

5650: -- End addition by sguthiva for bug 2307804
5651: IF p_party_account_rec.expire_flag = fnd_api.g_false -- Added by sguthiva for bug 2307804
5652: -- IF csi_party_relationships_pvt.g_force_expire_flag = 'N' -- Commented by sguthiva for bug 2307804
5653: THEN
5654: FND_MESSAGE.Set_Name('CSI', 'CSI_API_EXP_NOT_ALLOWED');
5655: FND_MESSAGE.Set_Token('COLUMN', 'OWNER ACCOUNT');
5656: FND_MSG_PUB.ADD;
5657: RAISE FND_API.G_EXC_ERROR;
5658: END IF;

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

5651: IF p_party_account_rec.expire_flag = fnd_api.g_false -- Added by sguthiva for bug 2307804
5652: -- IF csi_party_relationships_pvt.g_force_expire_flag = 'N' -- Commented by sguthiva for bug 2307804
5653: THEN
5654: FND_MESSAGE.Set_Name('CSI', 'CSI_API_EXP_NOT_ALLOWED');
5655: FND_MESSAGE.Set_Token('COLUMN', 'OWNER ACCOUNT');
5656: FND_MSG_PUB.ADD;
5657: RAISE FND_API.G_EXC_ERROR;
5658: END IF;
5659: ELSE

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

5676: 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
5677: l_curr_party_acct_rec.ACTIVE_START_DATE <> FND_API.G_MISS_DATE AND
5678: p_party_account_rec.ACTIVE_END_DATE < l_curr_party_acct_rec.ACTIVE_START_DATE
5679: THEN
5680: FND_MESSAGE.Set_Name('CSI', 'CSI_ENDDT_GT_STDT');
5681:
5682: FND_MESSAGE.Set_Token('END_DATE',p_party_account_rec.ACTIVE_END_DATE);
5683: FND_MESSAGE.Set_Token('START_DATE',l_curr_party_acct_rec.ACTIVE_START_DATE);
5684: FND_MSG_PUB.ADD;

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

5678: p_party_account_rec.ACTIVE_END_DATE < l_curr_party_acct_rec.ACTIVE_START_DATE
5679: THEN
5680: FND_MESSAGE.Set_Name('CSI', 'CSI_ENDDT_GT_STDT');
5681:
5682: FND_MESSAGE.Set_Token('END_DATE',p_party_account_rec.ACTIVE_END_DATE);
5683: FND_MESSAGE.Set_Token('START_DATE',l_curr_party_acct_rec.ACTIVE_START_DATE);
5684: FND_MSG_PUB.ADD;
5685: RAISE FND_API.G_EXC_ERROR;
5686: END IF;

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

5679: THEN
5680: FND_MESSAGE.Set_Name('CSI', 'CSI_ENDDT_GT_STDT');
5681:
5682: FND_MESSAGE.Set_Token('END_DATE',p_party_account_rec.ACTIVE_END_DATE);
5683: FND_MESSAGE.Set_Token('START_DATE',l_curr_party_acct_rec.ACTIVE_START_DATE);
5684: FND_MSG_PUB.ADD;
5685: RAISE FND_API.G_EXC_ERROR;
5686: END IF;
5687: -- End code addition for bug 3855525.

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

5696: IF p_party_account_rec.relationship_type_code <> FND_API.G_MISS_CHAR THEN
5697: IF ((p_party_account_rec.relationship_type_code <> l_curr_party_acct_rec.relationship_type_code)
5698: AND (l_curr_party_acct_rec.relationship_type_code = 'OWNER')
5699: AND (l_party_relation = 'OWNER')) THEN
5700: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
5701: FND_MESSAGE.Set_Token('COLUMN', 'OWNER ACCOUNT');
5702: FND_MSG_PUB.ADD;
5703: RAISE FND_API.G_EXC_ERROR;
5704: ELSE

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

5697: IF ((p_party_account_rec.relationship_type_code <> l_curr_party_acct_rec.relationship_type_code)
5698: AND (l_curr_party_acct_rec.relationship_type_code = 'OWNER')
5699: AND (l_party_relation = 'OWNER')) THEN
5700: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
5701: FND_MESSAGE.Set_Token('COLUMN', 'OWNER ACCOUNT');
5702: FND_MSG_PUB.ADD;
5703: RAISE FND_API.G_EXC_ERROR;
5704: ELSE
5705: -- Verify the relationship_type_code is valid

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

5963: --
5964: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
5965: --
5966: IF l_full_dump_frequency IS NULL THEN
5967: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_FULL_DUMP_FAILED');
5968: FND_MSG_PUB.ADD;
5969: RAISE FND_API.G_EXC_ERROR;
5970: END IF;
5971: --

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

6920: --
6921: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
6922: --
6923: IF l_internal_party_id IS NULL THEN
6924: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
6925: FND_MSG_PUB.ADD;
6926: RAISE FND_API.G_EXC_ERROR;
6927: END IF;
6928: -- Commenting as we are not using this code

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

7289:
7290: -- Check if the instance party id is valid
7291: IF NOT(CSI_Instance_parties_vld_pvt.Is_Ip_account_Valid
7292: (p_party_account_rec.ip_account_id))THEN
7293: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_IP_ACCOUNT_ID');
7294: FND_MESSAGE.SET_TOKEN('IP_ACCOUNT_ID',p_party_account_rec.ip_account_id);
7295: FND_MSG_PUB.Add;
7296: RAISE FND_API.G_EXC_ERROR;
7297: END IF;

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

7290: -- Check if the instance party id is valid
7291: IF NOT(CSI_Instance_parties_vld_pvt.Is_Ip_account_Valid
7292: (p_party_account_rec.ip_account_id))THEN
7293: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_IP_ACCOUNT_ID');
7294: FND_MESSAGE.SET_TOKEN('IP_ACCOUNT_ID',p_party_account_rec.ip_account_id);
7295: FND_MSG_PUB.Add;
7296: RAISE FND_API.G_EXC_ERROR;
7297: END IF;
7298: -- check if the object_version_number passed matches with the one

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

7300: OPEN get_curr_party_acct_rec(p_party_account_rec.ip_account_id);
7301: FETCH get_curr_party_acct_rec INTO l_curr_party_acct_rec;
7302:
7303: IF (l_curr_party_acct_rec.object_version_number <> p_party_account_rec.OBJECT_VERSION_NUMBER) THEN
7304: FND_MESSAGE.Set_Name('CSI', 'CSI_API_OBJ_VER_MISMATCH');
7305: FND_MSG_PUB.ADD;
7306: RAISE FND_API.G_EXC_ERROR;
7307: END IF;
7308: --

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

7306: RAISE FND_API.G_EXC_ERROR;
7307: END IF;
7308: --
7309: IF get_curr_party_acct_rec%NOTFOUND THEN
7310: FND_MESSAGE.Set_Name('CSI', 'CSI_API_RECORD_LOCKED');
7311: FND_MSG_PUB.ADD;
7312: RAISE FND_API.G_EXC_ERROR;
7313: END IF;
7314: CLOSE get_curr_party_acct_rec;

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

7477: IF ( ( p_contact_party_id IS NULL OR p_contact_party_id = fnd_api.g_miss_num )
7478: OR ( p_party_tbl IS NULL OR p_party_tbl = fnd_api.g_miss_char )
7479: )
7480: THEN
7481: fnd_message.set_name('CSI', 'CSI_API_INVALID_PARAMETERS');
7482: fnd_msg_pub.add;
7483: x_return_status := fnd_api.g_ret_sts_error;
7484: RAISE fnd_api.g_exc_error;
7485: END IF;

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

8520:
8521: -- End addition for bug 2179142
8522: i := i + 1;
8523: --IF get_party_hist%NOTFOUND THEN
8524: --FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_TXN_ID');
8525: --FND_MSG_PUB.Add;
8526: --RAISE FND_API.G_EXC_ERROR;
8527: --END IF;
8528: END LOOP;