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_MSG_PUB

Line 264: -- FND_MSG_PUB.Add;

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;
268: END IF;

Line 1027: -- FND_MSG_PUB.Add;

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;
1031: END IF;

Line 1469: FND_MSG_PUB.initialize;

1465: END IF;
1466:
1467: -- Initialize message list if p_init_msg_list is set to TRUE.
1468: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1469: FND_MSG_PUB.initialize;
1470: END IF;
1471:
1472: -- Initialize API return status to success
1473: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1603: x_msg_data := FND_MSG_PUB.GET(

1599: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1600: l_msg_index := 1;
1601: l_msg_count := x_msg_count;
1602: WHILE l_msg_count > 0 LOOP
1603: x_msg_data := FND_MSG_PUB.GET(
1604: l_msg_index,
1605: FND_API.G_FALSE );
1606: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
1607: l_msg_index := l_msg_index + 1;

Line 1673: FND_MSG_PUB.Add;

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;
1677: --

Line 1708: FND_MSG_PUB.Add;

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;
1712: END IF;

Line 1740: FND_MSG_PUB.ADD;

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: --
1744: -- Verify that the contact_ip_id is null, if the contact_flag is 'N'

Line 1753: FND_MSG_PUB.ADD;

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;
1757: --

Line 1778: FND_MSG_PUB.Add;

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
1782: WHEN NO_DATA_FOUND THEN

Line 1789: FND_MSG_PUB.Add;

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;
1793: END IF;

Line 1821: FND_MSG_PUB.Add;

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.
1825: END IF;

Line 1863: FND_MSG_PUB.Add;

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;
1867: --

Line 1900: FND_MSG_PUB.Add;

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;
1904: --

Line 1970: FND_MSG_PUB.Add;

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;
1974: END IF;

Line 1994: FND_MSG_PUB.Add;

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
1998: (p_party_rec.INSTANCE_ID,

Line 2040: fnd_msg_pub.Add;

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:
2044: -- Possible values for preferred flag are

Line 2054: fnd_msg_pub.Add;

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:
2058:

Line 2113: x_msg_data := FND_MSG_PUB.GET(

2109: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2110: l_msg_index := 1;
2111: l_msg_count := x_msg_count;
2112: WHILE l_msg_count > 0 LOOP
2113: x_msg_data := FND_MSG_PUB.GET(
2114: l_msg_index,
2115: FND_API.G_FALSE );
2116: csi_gen_utility_pvt.put_line( 'message data = '||x_msg_data);
2117: l_msg_index := l_msg_index + 1;

Line 2204: FND_MSG_PUB.Count_And_Get

2200: END IF;
2201:
2202:
2203: -- Standard call to get message count and if count is get message info.
2204: FND_MSG_PUB.Count_And_Get
2205: (p_count => x_msg_count ,
2206: p_data => x_msg_data );
2207: EXCEPTION
2208: WHEN FND_API.G_EXC_ERROR THEN

Line 2211: FND_MSG_PUB.Count_And_Get

2207: EXCEPTION
2208: WHEN FND_API.G_EXC_ERROR THEN
2209: ROLLBACK TO create_inst_party_rel_pvt;
2210: x_return_status := FND_API.G_RET_STS_ERROR ;
2211: FND_MSG_PUB.Count_And_Get
2212: ( p_count => x_msg_count,
2213: p_data => x_msg_data );
2214:
2215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2218: FND_MSG_PUB.Count_And_Get

2214:
2215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2216: ROLLBACK TO create_inst_party_rel_pvt;
2217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2218: FND_MSG_PUB.Count_And_Get
2219: ( p_count => x_msg_count,
2220: p_data => x_msg_data );
2221:
2222: WHEN OTHERS THEN

Line 2225: IF FND_MSG_PUB.Check_Msg_Level

2221:
2222: WHEN OTHERS THEN
2223: ROLLBACK TO create_inst_party_rel_pvt;
2224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2225: IF FND_MSG_PUB.Check_Msg_Level
2226: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2227: THEN
2228: FND_MSG_PUB.Add_Exc_Msg
2229: ( g_pkg_name ,

Line 2226: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2222: WHEN OTHERS THEN
2223: ROLLBACK TO create_inst_party_rel_pvt;
2224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2225: IF FND_MSG_PUB.Check_Msg_Level
2226: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2227: THEN
2228: FND_MSG_PUB.Add_Exc_Msg
2229: ( g_pkg_name ,
2230: l_api_name );

Line 2228: FND_MSG_PUB.Add_Exc_Msg

2224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2225: IF FND_MSG_PUB.Check_Msg_Level
2226: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2227: THEN
2228: FND_MSG_PUB.Add_Exc_Msg
2229: ( g_pkg_name ,
2230: l_api_name );
2231: END IF;
2232: FND_MSG_PUB.Count_And_Get

Line 2232: FND_MSG_PUB.Count_And_Get

2228: FND_MSG_PUB.Add_Exc_Msg
2229: ( g_pkg_name ,
2230: l_api_name );
2231: END IF;
2232: FND_MSG_PUB.Count_And_Get
2233: ( p_count => x_msg_count,
2234: p_data => x_msg_data );
2235: END create_inst_party_relationship;
2236:

Line 2578: FND_MSG_PUB.initialize;

2574: END IF;
2575:
2576: -- Initialize message list if p_init_msg_list is set to TRUE.
2577: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2578: FND_MSG_PUB.initialize;
2579: END IF;
2580:
2581: -- Initialize API return status to success
2582: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2612: FND_MSG_PUB.Add;

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: --
2616: -- Check if the instance party id is valid

Line 2691: FND_MSG_PUB.ADD;

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: --
2695: IF get_curr_party_rec%NOTFOUND THEN

Line 2697: FND_MSG_PUB.ADD;

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;
2701: --

Line 2706: FND_MSG_PUB.ADD;

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;
2710: --

Line 2714: FND_MSG_PUB.ADD;

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: --
2718: IF p_party_rec.active_start_date <> FND_API.G_MISS_DATE THEN

Line 2722: FND_MSG_PUB.ADD;

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;
2726: -- Increment the object_version_number before updating

Line 2734: FND_MSG_PUB.ADD;

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
2738: IF (g_expire_party_flag <> 'Y') THEN

Line 2757: FND_MSG_PUB.ADD;

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
2760:
2761:

Line 2809: FND_MSG_PUB.Add;

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;
2813: END IF;

Line 2873: FND_MSG_PUB.Add;

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
2877: -- SK ADDED

Line 2946: FND_MSG_PUB.ADD;

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
2950: IF ((p_party_rec.PARTY_ID <> FND_API.G_MISS_NUM)

Line 2973: x_msg_data := FND_MSG_PUB.GET(

2969: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2970: l_msg_index := 1;
2971: l_msg_count := x_msg_count;
2972: WHILE l_msg_count > 0 LOOP
2973: x_msg_data := FND_MSG_PUB.GET(
2974: l_msg_index,
2975: FND_API.G_FALSE );
2976: csi_gen_utility_pvt.put_line( 'message data = '||x_msg_data);
2977: l_msg_index := l_msg_index + 1;

Line 3060: FND_MSG_PUB.Add;

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;
3064: END;

Line 3107: fnd_msg_pub.Add;

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
3111: -- 'N','Y' and 'E'.

Line 3121: fnd_msg_pub.Add;

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
3125: CSI_I_PARTIES_PKG.Update_Row

Line 3178: x_msg_data := FND_MSG_PUB.GET(

3174: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3175: l_msg_index := 1;
3176: l_msg_count := x_msg_count;
3177: WHILE l_msg_count > 0 LOOP
3178: x_msg_data := FND_MSG_PUB.GET(
3179: l_msg_index,
3180: FND_API.G_FALSE );
3181: csi_gen_utility_pvt.put_line( 'message data = '||x_msg_data);
3182: l_msg_index := l_msg_index + 1;

Line 3197: FND_MSG_PUB.ADD;

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
3201: l_inst_party_his_id := CSI_Instance_parties_vld_pvt.gen_inst_party_hist_id;

Line 4214: FND_MSG_PUB.Get(p_msg_index => i,

4210: );
4211:
4212: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4213: FOR i in 1..x_msg_Count LOOP
4214: FND_MSG_PUB.Get(p_msg_index => i,
4215: p_encoded => 'F',
4216: p_data => x_msg_data,
4217: p_msg_index_out => x_msg_index_out );
4218: End LOOP;

Line 4246: FND_MSG_PUB.Get(p_msg_index => i,

4242: ,x_msg_data => x_msg_data
4243: );
4244: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4245: FOR i in 1..x_msg_Count LOOP
4246: FND_MSG_PUB.Get(p_msg_index => i,
4247: p_encoded => 'F',
4248: p_data => x_msg_data,
4249: p_msg_index_out => x_msg_index_out );
4250: End LOOP;

Line 4261: FND_MSG_PUB.Count_And_Get

4257: IF FND_API.To_Boolean( p_commit ) THEN
4258: COMMIT WORK;
4259: END IF;
4260: -- Standard call to get message count and if count is get message info.
4261: FND_MSG_PUB.Count_And_Get
4262: (p_count => x_msg_count ,
4263: p_data => x_msg_data );
4264: EXCEPTION
4265: WHEN FND_API.G_EXC_ERROR THEN

Line 4268: FND_MSG_PUB.Count_And_Get

4264: EXCEPTION
4265: WHEN FND_API.G_EXC_ERROR THEN
4266: -- ROLLBACK TO update_inst_party_rel_pvt;
4267: x_return_status := FND_API.G_RET_STS_ERROR ;
4268: FND_MSG_PUB.Count_And_Get
4269: ( p_count => x_msg_count,
4270: p_data => x_msg_data );
4271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4272: -- ROLLBACK TO update_inst_party_rel_pvt;

Line 4274: FND_MSG_PUB.Count_And_Get

4270: p_data => x_msg_data );
4271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4272: -- ROLLBACK TO update_inst_party_rel_pvt;
4273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4274: FND_MSG_PUB.Count_And_Get
4275: ( p_count => x_msg_count,
4276: p_data => x_msg_data );
4277: WHEN OTHERS THEN
4278: -- ROLLBACK TO update_inst_party_rel_pvt;

Line 4280: IF FND_MSG_PUB.Check_Msg_Level

4276: p_data => x_msg_data );
4277: WHEN OTHERS THEN
4278: -- ROLLBACK TO update_inst_party_rel_pvt;
4279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4280: IF FND_MSG_PUB.Check_Msg_Level
4281: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4282: THEN
4283: FND_MSG_PUB.Add_Exc_Msg
4284: ( g_pkg_name, l_api_name );

Line 4281: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4277: WHEN OTHERS THEN
4278: -- ROLLBACK TO update_inst_party_rel_pvt;
4279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4280: IF FND_MSG_PUB.Check_Msg_Level
4281: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4282: THEN
4283: FND_MSG_PUB.Add_Exc_Msg
4284: ( g_pkg_name, l_api_name );
4285: END IF;

Line 4283: FND_MSG_PUB.Add_Exc_Msg

4279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4280: IF FND_MSG_PUB.Check_Msg_Level
4281: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4282: THEN
4283: FND_MSG_PUB.Add_Exc_Msg
4284: ( g_pkg_name, l_api_name );
4285: END IF;
4286: FND_MSG_PUB.Count_And_Get
4287: ( p_count => x_msg_count,

Line 4286: FND_MSG_PUB.Count_And_Get

4282: THEN
4283: FND_MSG_PUB.Add_Exc_Msg
4284: ( g_pkg_name, l_api_name );
4285: END IF;
4286: FND_MSG_PUB.Count_And_Get
4287: ( p_count => x_msg_count,
4288: p_data => x_msg_data );
4289:
4290: END update_inst_party_relationship ;

Line 4380: FND_MSG_PUB.initialize;

4376: END IF;
4377:
4378: -- Initialize message list if p_init_msg_list is set to TRUE.
4379: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4380: FND_MSG_PUB.initialize;
4381: END IF;
4382:
4383: -- Initialize API return status to success
4384: -- Verify if the Party rel combination exists

Line 4429: -- FND_MSG_PUB.Add;

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
4433: -- in the database else raise error

Line 4438: FND_MSG_PUB.ADD;

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: --
4442: IF get_curr_party_rec%NOTFOUND THEN

Line 4444: FND_MSG_PUB.ADD;

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;
4448: -- Initialize all the parameters and call update_inst_party_relationship to expire the record

Line 4493: x_msg_data := FND_MSG_PUB.GET(

4489: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4490: l_msg_index := 1;
4491: l_msg_count := x_msg_count;
4492: WHILE l_msg_count > 0 LOOP
4493: x_msg_data := FND_MSG_PUB.GET(
4494: l_msg_index,
4495: FND_API.G_FALSE );
4496: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
4497: l_msg_index := l_msg_index + 1;

Line 4510: FND_MSG_PUB.Count_And_Get

4506: IF FND_API.To_Boolean( p_commit ) THEN
4507: COMMIT WORK;
4508: END IF;
4509: -- Standard call to get message count and if count is get message info.
4510: FND_MSG_PUB.Count_And_Get
4511: (p_count => x_msg_count ,
4512: p_data => x_msg_data );
4513: EXCEPTION
4514: WHEN FND_API.G_EXC_ERROR THEN

Line 4517: FND_MSG_PUB.Count_And_Get

4513: EXCEPTION
4514: WHEN FND_API.G_EXC_ERROR THEN
4515: -- ROLLBACK TO expire_inst_party_rel_pvt;
4516: x_return_status := FND_API.G_RET_STS_ERROR ;
4517: FND_MSG_PUB.Count_And_Get
4518: ( p_count => x_msg_count,
4519: p_data => x_msg_data );
4520: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4521: -- ROLLBACK TO expire_inst_party_rel_pvt;

Line 4523: FND_MSG_PUB.Count_And_Get

4519: p_data => x_msg_data );
4520: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4521: -- ROLLBACK TO expire_inst_party_rel_pvt;
4522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4523: FND_MSG_PUB.Count_And_Get
4524: ( p_count => x_msg_count,
4525: p_data => x_msg_data );
4526: WHEN OTHERS THEN
4527: -- ROLLBACK TO expire_inst_party_rel_pvt;

Line 4529: IF FND_MSG_PUB.Check_Msg_Level

4525: p_data => x_msg_data );
4526: WHEN OTHERS THEN
4527: -- ROLLBACK TO expire_inst_party_rel_pvt;
4528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4529: IF FND_MSG_PUB.Check_Msg_Level
4530: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4531: THEN
4532: FND_MSG_PUB.Add_Exc_Msg
4533: ( g_pkg_name, l_api_name );

Line 4530: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4526: WHEN OTHERS THEN
4527: -- ROLLBACK TO expire_inst_party_rel_pvt;
4528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4529: IF FND_MSG_PUB.Check_Msg_Level
4530: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4531: THEN
4532: FND_MSG_PUB.Add_Exc_Msg
4533: ( g_pkg_name, l_api_name );
4534: END IF;

Line 4532: FND_MSG_PUB.Add_Exc_Msg

4528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4529: IF FND_MSG_PUB.Check_Msg_Level
4530: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4531: THEN
4532: FND_MSG_PUB.Add_Exc_Msg
4533: ( g_pkg_name, l_api_name );
4534: END IF;
4535: FND_MSG_PUB.Count_And_Get
4536: ( p_count => x_msg_count,

Line 4535: FND_MSG_PUB.Count_And_Get

4531: THEN
4532: FND_MSG_PUB.Add_Exc_Msg
4533: ( g_pkg_name, l_api_name );
4534: END IF;
4535: FND_MSG_PUB.Count_And_Get
4536: ( p_count => x_msg_count,
4537: p_data => x_msg_data );
4538: END expire_inst_party_relationship;
4539:

Line 4606: FND_MSG_PUB.initialize;

4602: END IF;
4603:
4604: -- Initialize message list if p_init_msg_list is set to TRUE.
4605: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4606: FND_MSG_PUB.initialize;
4607: END IF;
4608:
4609: -- Initialize API return status to success
4610: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4734: x_msg_data := FND_MSG_PUB.GET(

4730: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4731: l_msg_index := 1;
4732: l_msg_count := x_msg_count;
4733: WHILE l_msg_count > 0 LOOP
4734: x_msg_data := FND_MSG_PUB.GET(
4735: l_msg_index,
4736: FND_API.G_FALSE );
4737: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
4738: l_msg_index := l_msg_index + 1;

Line 4805: x_msg_data := FND_MSG_PUB.GET(

4801: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4802: l_msg_index := 1;
4803: l_msg_count := x_msg_count;
4804: WHILE l_msg_count > 0 LOOP
4805: x_msg_data := FND_MSG_PUB.GET(
4806: l_msg_index,
4807: FND_API.G_FALSE );
4808: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
4809: l_msg_index := l_msg_index + 1;

Line 4863: FND_MSG_PUB.Add;

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;
4867: --

Line 4881: -- FND_MSG_PUB.Add;

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';
4885: END IF;

Line 4918: FND_MSG_PUB.Add;

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;
4922: IF l_exists_flag <> 'Y' THEN

Line 4984: FND_MSG_PUB.Add;

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;
4988: --

Line 5024: FND_MSG_PUB.Add;

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;
5028: --

Line 5128: x_msg_data := FND_MSG_PUB.GET(

5124: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5125: l_msg_index := 1;
5126: l_msg_count := x_msg_count;
5127: WHILE l_msg_count > 0 LOOP
5128: x_msg_data := FND_MSG_PUB.GET(
5129: l_msg_index,
5130: FND_API.G_FALSE );
5131: csi_gen_utility_pvt.put_line( 'message data = '||x_msg_data);
5132: l_msg_index := l_msg_index + 1;

Line 5252: x_msg_data := FND_MSG_PUB.GET(

5248: THEN
5249: l_msg_index := 1;
5250: l_msg_count := x_msg_count;
5251: WHILE l_msg_count > 0 LOOP
5252: x_msg_data := FND_MSG_PUB.GET(
5253: l_msg_index,
5254: FND_API.G_FALSE );
5255: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
5256: l_msg_index := l_msg_index + 1;

Line 5276: FND_MSG_PUB.Count_And_Get

5272: END IF;
5273:
5274:
5275: -- Standard call to get message count and if count is get message info.
5276: FND_MSG_PUB.Count_And_Get
5277: (p_count => x_msg_count ,
5278: p_data => x_msg_data );
5279: EXCEPTION
5280: WHEN FND_API.G_EXC_ERROR THEN

Line 5284: FND_MSG_PUB.Count_And_Get

5280: WHEN FND_API.G_EXC_ERROR THEN
5281: ROLLBACK TO create_inst_party_acct_pvt;
5282: x_return_status := FND_API.G_RET_STS_ERROR ;
5283:
5284: FND_MSG_PUB.Count_And_Get
5285: ( p_count => x_msg_count,
5286: p_data => x_msg_data );
5287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5288: ROLLBACK TO create_inst_party_acct_pvt;

Line 5290: FND_MSG_PUB.Count_And_Get

5286: p_data => x_msg_data );
5287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5288: ROLLBACK TO create_inst_party_acct_pvt;
5289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5290: FND_MSG_PUB.Count_And_Get
5291: ( p_count => x_msg_count,
5292: p_data => x_msg_data );
5293: WHEN OTHERS THEN
5294: ROLLBACK TO create_inst_party_acct_pvt;

Line 5296: IF FND_MSG_PUB.Check_Msg_Level

5292: p_data => x_msg_data );
5293: WHEN OTHERS THEN
5294: ROLLBACK TO create_inst_party_acct_pvt;
5295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5296: IF FND_MSG_PUB.Check_Msg_Level
5297: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5298: THEN
5299: FND_MSG_PUB.Add_Exc_Msg
5300: ( g_pkg_name, l_api_name );

Line 5297: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5293: WHEN OTHERS THEN
5294: ROLLBACK TO create_inst_party_acct_pvt;
5295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5296: IF FND_MSG_PUB.Check_Msg_Level
5297: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5298: THEN
5299: FND_MSG_PUB.Add_Exc_Msg
5300: ( g_pkg_name, l_api_name );
5301: END IF;

Line 5299: FND_MSG_PUB.Add_Exc_Msg

5295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5296: IF FND_MSG_PUB.Check_Msg_Level
5297: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5298: THEN
5299: FND_MSG_PUB.Add_Exc_Msg
5300: ( g_pkg_name, l_api_name );
5301: END IF;
5302: FND_MSG_PUB.Count_And_Get
5303: ( p_count => x_msg_count,

Line 5302: FND_MSG_PUB.Count_And_Get

5298: THEN
5299: FND_MSG_PUB.Add_Exc_Msg
5300: ( g_pkg_name, l_api_name );
5301: END IF;
5302: FND_MSG_PUB.Count_And_Get
5303: ( p_count => x_msg_count,
5304: p_data => x_msg_data );
5305:
5306: END create_inst_party_account;

Line 5481: FND_MSG_PUB.initialize;

5477: END IF;
5478:
5479: -- Initialize message list if p_init_msg_list is set to TRUE.
5480: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5481: FND_MSG_PUB.initialize;
5482: END IF;
5483:
5484: -- Initialize API return status to success
5485: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5516: FND_MSG_PUB.Add;

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: --
5520: -- Check if the instance party id is valid

Line 5530: FND_MSG_PUB.ADD;

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
5534: FND_MESSAGE.Set_Name('CSI', 'CSI_API_RECORD_LOCKED');

Line 5535: 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;
5539:

Line 5562: -- FND_MSG_PUB.Add;

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
5566: -- Start addition

Line 5571: FND_MSG_PUB.ADD;

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
5575: SELECT relationship_type_code

Line 5590: FND_MSG_PUB.ADD;

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
5594: WHEN FND_API.G_EXC_ERROR THEN

Line 5619: FND_MSG_PUB.ADD;

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: --
5623: IF p_party_account_rec.active_start_date <> FND_API.G_MISS_DATE THEN

Line 5627: FND_MSG_PUB.ADD;

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;
5631:

Line 5646: FND_MSG_PUB.ADD;

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: --
5650: -- End addition by sguthiva for bug 2307804

Line 5656: FND_MSG_PUB.ADD;

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
5660:

Line 5684: FND_MSG_PUB.ADD;

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.
5688:

Line 5702: FND_MSG_PUB.ADD;

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
5706: IF NOT(CSI_Instance_parties_vld_pvt.Is_Acct_Rel_type_Valid

Line 5945: FND_MSG_PUB.Get(p_msg_index => i,

5941:
5942: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5943:
5944: FOR i in 1..x_msg_Count LOOP
5945: FND_MSG_PUB.Get(p_msg_index => i,
5946: p_encoded => 'F',
5947: p_data => x_msg_data,
5948: p_msg_index_out => x_msg_index_out );
5949: csi_gen_utility_pvt.put_line( 'message data = '||x_msg_data);

Line 5968: FND_MSG_PUB.ADD;

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: --
5972: select mod(l_object_version_number,l_full_dump_frequency)

Line 6925: FND_MSG_PUB.ADD;

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
6929: -- Uncommented following code for bug 13614080

Line 7030: x_msg_data := FND_MSG_PUB.GET(

7026: csi_gen_utility_pvt.put_line('Cascade Ownership - Call to contracts with TRM txn type has errored ');
7027: l_msg_index := 1;
7028: l_msg_count := x_msg_count;
7029: WHILE l_msg_count > 0 LOOP
7030: x_msg_data := FND_MSG_PUB.GET(
7031: l_msg_index,
7032: FND_API.G_FALSE );
7033: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
7034: l_msg_index := l_msg_index + 1;

Line 7063: x_msg_data := FND_MSG_PUB.GET(

7059: csi_gen_utility_pvt.put_line('Cascade Ownership - Call to contracts with NEW txn type has errored ');
7060: l_msg_index := 1;
7061: l_msg_count := x_msg_count;
7062: WHILE l_msg_count > 0 LOOP
7063: x_msg_data := FND_MSG_PUB.GET(
7064: l_msg_index,
7065: FND_API.G_FALSE );
7066: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
7067: l_msg_index := l_msg_index + 1;

Line 7116: x_msg_data := FND_MSG_PUB.GET(

7112: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
7113: l_msg_index := 1;
7114: l_msg_count := x_msg_count;
7115: WHILE l_msg_count > 0 LOOP
7116: x_msg_data := FND_MSG_PUB.GET(
7117: l_msg_index,
7118: FND_API.G_FALSE );
7119: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
7120: l_msg_index := l_msg_index + 1;

Line 7135: FND_MSG_PUB.Count_And_Get

7131: IF FND_API.To_Boolean( p_commit ) THEN
7132: COMMIT WORK;
7133: END IF;
7134: -- Standard call to get message count and if count is get message info.
7135: FND_MSG_PUB.Count_And_Get
7136: (p_count => x_msg_count ,
7137: p_data => x_msg_data );
7138: EXCEPTION
7139: WHEN FND_API.G_EXC_ERROR THEN

Line 7142: FND_MSG_PUB.Count_And_Get

7138: EXCEPTION
7139: WHEN FND_API.G_EXC_ERROR THEN
7140: -- ROLLBACK TO update_inst_party_acct_pvt;
7141: x_return_status := FND_API.G_RET_STS_ERROR ;
7142: FND_MSG_PUB.Count_And_Get
7143: ( p_count => x_msg_count,
7144: p_data => x_msg_data );
7145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7146: -- ROLLBACK TO update_inst_party_acct_pvt;

Line 7148: FND_MSG_PUB.Count_And_Get

7144: p_data => x_msg_data );
7145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7146: -- ROLLBACK TO update_inst_party_acct_pvt;
7147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7148: FND_MSG_PUB.Count_And_Get
7149: ( p_count => x_msg_count,
7150: p_data => x_msg_data );
7151: WHEN OTHERS THEN
7152: -- ROLLBACK TO update_inst_party_acct_pvt;

Line 7154: IF FND_MSG_PUB.Check_Msg_Level

7150: p_data => x_msg_data );
7151: WHEN OTHERS THEN
7152: -- ROLLBACK TO update_inst_party_acct_pvt;
7153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7154: IF FND_MSG_PUB.Check_Msg_Level
7155: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7156: THEN
7157: FND_MSG_PUB.Add_Exc_Msg
7158: ( g_pkg_name, l_api_name );

Line 7155: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

7151: WHEN OTHERS THEN
7152: -- ROLLBACK TO update_inst_party_acct_pvt;
7153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7154: IF FND_MSG_PUB.Check_Msg_Level
7155: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7156: THEN
7157: FND_MSG_PUB.Add_Exc_Msg
7158: ( g_pkg_name, l_api_name );
7159: END IF;

Line 7157: FND_MSG_PUB.Add_Exc_Msg

7153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7154: IF FND_MSG_PUB.Check_Msg_Level
7155: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7156: THEN
7157: FND_MSG_PUB.Add_Exc_Msg
7158: ( g_pkg_name, l_api_name );
7159: END IF;
7160: FND_MSG_PUB.Count_And_Get
7161: ( p_count => x_msg_count,

Line 7160: FND_MSG_PUB.Count_And_Get

7156: THEN
7157: FND_MSG_PUB.Add_Exc_Msg
7158: ( g_pkg_name, l_api_name );
7159: END IF;
7160: FND_MSG_PUB.Count_And_Get
7161: ( p_count => x_msg_count,
7162: p_data => x_msg_data );
7163: END update_inst_party_account ;
7164:

Line 7250: FND_MSG_PUB.initialize;

7246: END IF;
7247:
7248: -- Initialize message list if p_init_msg_list is set to TRUE.
7249: IF FND_API.to_Boolean( p_init_msg_list ) THEN
7250: FND_MSG_PUB.initialize;
7251: END IF;
7252:
7253: -- Initialize API return status to success
7254: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 7295: FND_MSG_PUB.Add;

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
7299: -- in the database else raise error

Line 7305: FND_MSG_PUB.ADD;

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: --
7309: IF get_curr_party_acct_rec%NOTFOUND THEN

Line 7311: FND_MSG_PUB.ADD;

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;
7315: -- Initialize all the parameters and call upate_inst_party_account to expire the record

Line 7370: x_msg_data := FND_MSG_PUB.GET(

7366: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
7367: l_msg_index := 1;
7368: l_msg_count := x_msg_count;
7369: WHILE l_msg_count > 0 LOOP
7370: x_msg_data := FND_MSG_PUB.GET(
7371: l_msg_index,
7372: FND_API.G_FALSE );
7373: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
7374: l_msg_index := l_msg_index + 1;

Line 7388: FND_MSG_PUB.Count_And_Get

7384: IF FND_API.To_Boolean( p_commit ) THEN
7385: COMMIT WORK;
7386: END IF;
7387: -- Standard call to get message count and if count is get message info.
7388: FND_MSG_PUB.Count_And_Get
7389: (p_count => x_msg_count ,
7390: p_data => x_msg_data );
7391: EXCEPTION
7392: WHEN FND_API.G_EXC_ERROR THEN

Line 7395: FND_MSG_PUB.Count_And_Get

7391: EXCEPTION
7392: WHEN FND_API.G_EXC_ERROR THEN
7393: ROLLBACK TO expire_inst_party_acct_pvt;
7394: x_return_status := FND_API.G_RET_STS_ERROR ;
7395: FND_MSG_PUB.Count_And_Get
7396: ( p_count => x_msg_count,
7397: p_data => x_msg_data );
7398:
7399: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 7402: FND_MSG_PUB.Count_And_Get

7398:
7399: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7400: ROLLBACK TO expire_inst_party_acct_pvt;
7401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7402: FND_MSG_PUB.Count_And_Get
7403: ( p_count => x_msg_count,
7404: p_data => x_msg_data );
7405: WHEN OTHERS THEN
7406: ROLLBACK TO expire_inst_party_acct_pvt;

Line 7408: IF FND_MSG_PUB.Check_Msg_Level

7404: p_data => x_msg_data );
7405: WHEN OTHERS THEN
7406: ROLLBACK TO expire_inst_party_acct_pvt;
7407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7408: IF FND_MSG_PUB.Check_Msg_Level
7409: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7410: THEN
7411: FND_MSG_PUB.Add_Exc_Msg
7412: ( g_pkg_name, l_api_name );

Line 7409: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

7405: WHEN OTHERS THEN
7406: ROLLBACK TO expire_inst_party_acct_pvt;
7407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7408: IF FND_MSG_PUB.Check_Msg_Level
7409: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7410: THEN
7411: FND_MSG_PUB.Add_Exc_Msg
7412: ( g_pkg_name, l_api_name );
7413: END IF;

Line 7411: FND_MSG_PUB.Add_Exc_Msg

7407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7408: IF FND_MSG_PUB.Check_Msg_Level
7409: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7410: THEN
7411: FND_MSG_PUB.Add_Exc_Msg
7412: ( g_pkg_name, l_api_name );
7413: END IF;
7414: FND_MSG_PUB.Count_And_Get
7415: ( p_count => x_msg_count,

Line 7414: FND_MSG_PUB.Count_And_Get

7410: THEN
7411: FND_MSG_PUB.Add_Exc_Msg
7412: ( g_pkg_name, l_api_name );
7413: END IF;
7414: FND_MSG_PUB.Count_And_Get
7415: ( p_count => x_msg_count,
7416: p_data => x_msg_data );
7417: END expire_inst_party_account ;
7418:

Line 7460: FND_MSG_PUB.initialize;

7456: END IF;
7457:
7458: -- Initialize message list if p_init_msg_list is set to TRUE.
7459: IF FND_API.to_Boolean( p_init_msg_list ) THEN
7460: FND_MSG_PUB.initialize;
7461: END IF;
7462:
7463: -- Initialize API return status to success
7464: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 7482: fnd_msg_pub.add;

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;
7486:

Line 7811: FND_MSG_PUB.Count_And_Get

7807: END IF;
7808: */
7809:
7810: -- Standard call to get message count and if count is get message info.
7811: FND_MSG_PUB.Count_And_Get
7812: (p_count => x_msg_count ,
7813: p_data => x_msg_data );
7814: EXCEPTION
7815: WHEN FND_API.G_EXC_ERROR THEN

Line 7818: FND_MSG_PUB.Count_And_Get

7814: EXCEPTION
7815: WHEN FND_API.G_EXC_ERROR THEN
7816: -- ROLLBACK TO get_contact_details_pvt;
7817: x_return_status := FND_API.G_RET_STS_ERROR ;
7818: FND_MSG_PUB.Count_And_Get
7819: ( p_count => x_msg_count,
7820: p_data => x_msg_data );
7821: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7822: -- ROLLBACK TO get_contact_details_pvt;

Line 7824: FND_MSG_PUB.Count_And_Get

7820: p_data => x_msg_data );
7821: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7822: -- ROLLBACK TO get_contact_details_pvt;
7823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7824: FND_MSG_PUB.Count_And_Get
7825: ( p_count => x_msg_count,
7826: p_data => x_msg_data );
7827: WHEN OTHERS THEN
7828: -- ROLLBACK TO get_contact_details_pvt;

Line 7830: IF FND_MSG_PUB.Check_Msg_Level

7826: p_data => x_msg_data );
7827: WHEN OTHERS THEN
7828: -- ROLLBACK TO get_contact_details_pvt;
7829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7830: IF FND_MSG_PUB.Check_Msg_Level
7831: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7832: THEN
7833: FND_MSG_PUB.Add_Exc_Msg
7834: ( g_pkg_name, l_api_name );

Line 7831: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

7827: WHEN OTHERS THEN
7828: -- ROLLBACK TO get_contact_details_pvt;
7829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7830: IF FND_MSG_PUB.Check_Msg_Level
7831: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7832: THEN
7833: FND_MSG_PUB.Add_Exc_Msg
7834: ( g_pkg_name, l_api_name );
7835: END IF;

Line 7833: FND_MSG_PUB.Add_Exc_Msg

7829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7830: IF FND_MSG_PUB.Check_Msg_Level
7831: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7832: THEN
7833: FND_MSG_PUB.Add_Exc_Msg
7834: ( g_pkg_name, l_api_name );
7835: END IF;
7836: FND_MSG_PUB.Count_And_Get
7837: ( p_count => x_msg_count,

Line 7836: FND_MSG_PUB.Count_And_Get

7832: THEN
7833: FND_MSG_PUB.Add_Exc_Msg
7834: ( g_pkg_name, l_api_name );
7835: END IF;
7836: FND_MSG_PUB.Count_And_Get
7837: ( p_count => x_msg_count,
7838: p_data => x_msg_data );
7839:
7840: END get_contact_details ;

Line 7965: FND_MSG_PUB.initialize;

7961: END IF;
7962:
7963: -- Initialize message list if p_init_msg_list is set to TRUE.
7964: IF FND_API.to_Boolean( p_init_msg_list ) THEN
7965: FND_MSG_PUB.initialize;
7966: END IF;
7967:
7968: -- Initialize API return status to success
7969: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 8148: FND_MSG_PUB.Get(p_msg_index => i,

8144:
8145:
8146: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
8147: FOR i in 1..x_msg_Count LOOP
8148: FND_MSG_PUB.Get(p_msg_index => i,
8149: p_encoded => 'F',
8150: p_data => x_msg_data,
8151: p_msg_index_out => x_msg_index_out );
8152: csi_gen_utility_pvt.put_line( 'message data = '||x_msg_data);

Line 8340: FND_MSG_PUB.Get(p_msg_index => i,

8336:
8337:
8338: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
8339: FOR i in 1..x_msg_Count LOOP
8340: FND_MSG_PUB.Get(p_msg_index => i,
8341: p_encoded => 'F',
8342: p_data => x_msg_data,
8343: p_msg_index_out => x_msg_index_out );
8344: csi_gen_utility_pvt.put_line( 'message data = '||x_msg_data);

Line 8525: --FND_MSG_PUB.Add;

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;
8529:

Line 8548: FND_MSG_PUB.Count_And_Get

8544: -- End disable trace
8545: ****/
8546:
8547: -- Standard call to get message count and if count is get message info.
8548: FND_MSG_PUB.Count_And_Get
8549: (p_count => x_msg_count ,
8550: p_data => x_msg_data );
8551: EXCEPTION
8552: WHEN FND_API.G_EXC_ERROR THEN

Line 8555: FND_MSG_PUB.Count_And_Get

8551: EXCEPTION
8552: WHEN FND_API.G_EXC_ERROR THEN
8553: -- ROLLBACK TO get_inst_party_rel_hist;
8554: x_return_status := FND_API.G_RET_STS_ERROR ;
8555: FND_MSG_PUB.Count_And_Get
8556: ( p_count => x_msg_count,
8557: p_data => x_msg_data );
8558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8559: -- ROLLBACK TO get_inst_party_rel_hist;

Line 8561: FND_MSG_PUB.Count_And_Get

8557: p_data => x_msg_data );
8558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8559: -- ROLLBACK TO get_inst_party_rel_hist;
8560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8561: FND_MSG_PUB.Count_And_Get
8562: ( p_count => x_msg_count,
8563: p_data => x_msg_data );
8564: WHEN OTHERS THEN
8565: -- ROLLBACK TO get_inst_party_rel_hist;

Line 8567: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

8563: p_data => x_msg_data );
8564: WHEN OTHERS THEN
8565: -- ROLLBACK TO get_inst_party_rel_hist;
8566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8567: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8568: FND_MSG_PUB.Add_Exc_Msg
8569: ( g_pkg_name ,
8570: l_api_name );
8571: END IF;

Line 8568: FND_MSG_PUB.Add_Exc_Msg

8564: WHEN OTHERS THEN
8565: -- ROLLBACK TO get_inst_party_rel_hist;
8566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8567: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8568: FND_MSG_PUB.Add_Exc_Msg
8569: ( g_pkg_name ,
8570: l_api_name );
8571: END IF;
8572: FND_MSG_PUB.Count_And_Get

Line 8572: FND_MSG_PUB.Count_And_Get

8568: FND_MSG_PUB.Add_Exc_Msg
8569: ( g_pkg_name ,
8570: l_api_name );
8571: END IF;
8572: FND_MSG_PUB.Count_And_Get
8573: ( p_count => x_msg_count,
8574: p_data => x_msg_data );
8575:
8576: END get_inst_party_rel_hist;

Line 8686: FND_MSG_PUB.initialize;

8682: END IF;
8683:
8684: -- Initialize message list if p_init_msg_list is set to TRUE.
8685: IF FND_API.to_Boolean( p_init_msg_list ) THEN
8686: FND_MSG_PUB.initialize;
8687: END IF;
8688:
8689: -- Initialize API return status to success
8690: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 9109: FND_MSG_PUB.Count_And_Get

9105: -- End disable trace
9106: ****/
9107:
9108: -- Standard call to get message count and if count is get message info.
9109: FND_MSG_PUB.Count_And_Get
9110: (p_count => x_msg_count ,
9111: p_data => x_msg_data );
9112: EXCEPTION
9113: WHEN FND_API.G_EXC_ERROR THEN

Line 9116: FND_MSG_PUB.Count_And_Get

9112: EXCEPTION
9113: WHEN FND_API.G_EXC_ERROR THEN
9114: -- ROLLBACK TO get_inst_party_account_hist;
9115: x_return_status := FND_API.G_RET_STS_ERROR ;
9116: FND_MSG_PUB.Count_And_Get
9117: ( p_count => x_msg_count,
9118: p_data => x_msg_data );
9119: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9120: -- ROLLBACK TO get_inst_party_account_hist;

Line 9122: FND_MSG_PUB.Count_And_Get

9118: p_data => x_msg_data );
9119: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9120: -- ROLLBACK TO get_inst_party_account_hist;
9121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9122: FND_MSG_PUB.Count_And_Get
9123: ( p_count => x_msg_count,
9124: p_data => x_msg_data );
9125: WHEN OTHERS THEN
9126: -- ROLLBACK TO get_inst_party_account_hist;

Line 9128: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

9124: p_data => x_msg_data );
9125: WHEN OTHERS THEN
9126: -- ROLLBACK TO get_inst_party_account_hist;
9127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9128: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9129: FND_MSG_PUB.Add_Exc_Msg
9130: ( g_pkg_name ,
9131: l_api_name );
9132: END IF;

Line 9129: FND_MSG_PUB.Add_Exc_Msg

9125: WHEN OTHERS THEN
9126: -- ROLLBACK TO get_inst_party_account_hist;
9127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9128: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9129: FND_MSG_PUB.Add_Exc_Msg
9130: ( g_pkg_name ,
9131: l_api_name );
9132: END IF;
9133: FND_MSG_PUB.Count_And_Get

Line 9133: FND_MSG_PUB.Count_And_Get

9129: FND_MSG_PUB.Add_Exc_Msg
9130: ( g_pkg_name ,
9131: l_api_name );
9132: END IF;
9133: FND_MSG_PUB.Count_And_Get
9134: ( p_count => x_msg_count,
9135: p_data => x_msg_data );
9136:
9137: END get_inst_party_account_hist;