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 2575: FND_MSG_PUB.initialize;

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

Line 2609: FND_MSG_PUB.Add;

2605: l_api_name );
2606: --
2607: IF p_party_rec.party_id IS NULL THEN
2608: FND_MESSAGE.SET_NAME('CSI','CSI_API_MANDATORY_PARTY');
2609: FND_MSG_PUB.Add;
2610: RAISE FND_API.G_EXC_ERROR;
2611: END IF;
2612: --
2613: -- Check if the instance party id is valid

Line 2671: FND_MSG_PUB.ADD;

2667: OPEN get_curr_party_rec(p_party_rec.INSTANCE_PARTY_ID);
2668: FETCH get_curr_party_rec INTO l_curr_party_rec;
2669: IF (l_curr_party_rec.object_version_number <> p_party_rec.OBJECT_VERSION_NUMBER) THEN
2670: FND_MESSAGE.Set_Name('CSI', 'CSI_API_OBJ_VER_MISMATCH');
2671: FND_MSG_PUB.ADD;
2672: RAISE FND_API.G_EXC_ERROR;
2673: END IF;
2674: --
2675: IF get_curr_party_rec%NOTFOUND THEN

Line 2677: FND_MSG_PUB.ADD;

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

Line 2686: FND_MSG_PUB.ADD;

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

Line 2694: FND_MSG_PUB.ADD;

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

Line 2702: FND_MSG_PUB.ADD;

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

Line 2714: FND_MSG_PUB.ADD;

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

Line 2737: FND_MSG_PUB.ADD;

2733: AND l_curr_party_rec.relationship_type_code = 'OWNER' ) THEN
2734: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
2735: FND_MESSAGE.Set_Token('COLUMN', 'OWNER PARTY');
2736:
2737: FND_MSG_PUB.ADD;
2738: RAISE FND_API.G_EXC_ERROR;
2739: ELSE
2740: -- Verify the relationship_type_code is valid
2741: IF p_party_rec.contact_flag = 'Y' THEN

Line 2772: FND_MSG_PUB.Add;

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

Line 2835: FND_MSG_PUB.Add;

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

Line 2907: FND_MSG_PUB.ADD;

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

Line 2934: x_msg_data := FND_MSG_PUB.GET(

2930: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2931: l_msg_index := 1;
2932: l_msg_count := x_msg_count;
2933: WHILE l_msg_count > 0 LOOP
2934: x_msg_data := FND_MSG_PUB.GET(
2935: l_msg_index,
2936: FND_API.G_FALSE );
2937: csi_gen_utility_pvt.put_line( 'message data = '||x_msg_data);
2938: l_msg_index := l_msg_index + 1;

Line 3021: FND_MSG_PUB.Add;

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

Line 3068: fnd_msg_pub.Add;

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

Line 3082: fnd_msg_pub.Add;

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

Line 3139: x_msg_data := FND_MSG_PUB.GET(

3135: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3136: l_msg_index := 1;
3137: l_msg_count := x_msg_count;
3138: WHILE l_msg_count > 0 LOOP
3139: x_msg_data := FND_MSG_PUB.GET(
3140: l_msg_index,
3141: FND_API.G_FALSE );
3142: csi_gen_utility_pvt.put_line( 'message data = '||x_msg_data);
3143: l_msg_index := l_msg_index + 1;

Line 3158: FND_MSG_PUB.ADD;

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

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

4171: );
4172:
4173: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4174: FOR i in 1..x_msg_Count LOOP
4175: FND_MSG_PUB.Get(p_msg_index => i,
4176: p_encoded => 'F',
4177: p_data => x_msg_data,
4178: p_msg_index_out => x_msg_index_out );
4179: End LOOP;

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

4203: ,x_msg_data => x_msg_data
4204: );
4205: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4206: FOR i in 1..x_msg_Count LOOP
4207: FND_MSG_PUB.Get(p_msg_index => i,
4208: p_encoded => 'F',
4209: p_data => x_msg_data,
4210: p_msg_index_out => x_msg_index_out );
4211: End LOOP;

Line 4222: FND_MSG_PUB.Count_And_Get

4218: IF FND_API.To_Boolean( p_commit ) THEN
4219: COMMIT WORK;
4220: END IF;
4221: -- Standard call to get message count and if count is get message info.
4222: FND_MSG_PUB.Count_And_Get
4223: (p_count => x_msg_count ,
4224: p_data => x_msg_data );
4225: EXCEPTION
4226: WHEN FND_API.G_EXC_ERROR THEN

Line 4229: FND_MSG_PUB.Count_And_Get

4225: EXCEPTION
4226: WHEN FND_API.G_EXC_ERROR THEN
4227: -- ROLLBACK TO update_inst_party_rel_pvt;
4228: x_return_status := FND_API.G_RET_STS_ERROR ;
4229: FND_MSG_PUB.Count_And_Get
4230: ( p_count => x_msg_count,
4231: p_data => x_msg_data );
4232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4233: -- ROLLBACK TO update_inst_party_rel_pvt;

Line 4235: FND_MSG_PUB.Count_And_Get

4231: p_data => x_msg_data );
4232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4233: -- ROLLBACK TO update_inst_party_rel_pvt;
4234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4235: FND_MSG_PUB.Count_And_Get
4236: ( p_count => x_msg_count,
4237: p_data => x_msg_data );
4238: WHEN OTHERS THEN
4239: -- ROLLBACK TO update_inst_party_rel_pvt;

Line 4241: IF FND_MSG_PUB.Check_Msg_Level

4237: p_data => x_msg_data );
4238: WHEN OTHERS THEN
4239: -- ROLLBACK TO update_inst_party_rel_pvt;
4240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4241: IF FND_MSG_PUB.Check_Msg_Level
4242: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4243: THEN
4244: FND_MSG_PUB.Add_Exc_Msg
4245: ( g_pkg_name, l_api_name );

Line 4242: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4238: WHEN OTHERS THEN
4239: -- ROLLBACK TO update_inst_party_rel_pvt;
4240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4241: IF FND_MSG_PUB.Check_Msg_Level
4242: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4243: THEN
4244: FND_MSG_PUB.Add_Exc_Msg
4245: ( g_pkg_name, l_api_name );
4246: END IF;

Line 4244: FND_MSG_PUB.Add_Exc_Msg

4240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4241: IF FND_MSG_PUB.Check_Msg_Level
4242: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4243: THEN
4244: FND_MSG_PUB.Add_Exc_Msg
4245: ( g_pkg_name, l_api_name );
4246: END IF;
4247: FND_MSG_PUB.Count_And_Get
4248: ( p_count => x_msg_count,

Line 4247: FND_MSG_PUB.Count_And_Get

4243: THEN
4244: FND_MSG_PUB.Add_Exc_Msg
4245: ( g_pkg_name, l_api_name );
4246: END IF;
4247: FND_MSG_PUB.Count_And_Get
4248: ( p_count => x_msg_count,
4249: p_data => x_msg_data );
4250:
4251: END update_inst_party_relationship ;

Line 4341: FND_MSG_PUB.initialize;

4337: END IF;
4338:
4339: -- Initialize message list if p_init_msg_list is set to TRUE.
4340: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4341: FND_MSG_PUB.initialize;
4342: END IF;
4343:
4344: -- Initialize API return status to success
4345: -- Verify if the Party rel combination exists

Line 4390: -- FND_MSG_PUB.Add;

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

Line 4399: FND_MSG_PUB.ADD;

4395: OPEN get_curr_party_rec(p_instance_party_rec.instance_party_id);
4396: FETCH get_curr_party_rec INTO l_curr_party_rec;
4397: IF (l_curr_party_rec.object_version_number <> p_instance_party_rec.OBJECT_VERSION_NUMBER) THEN
4398: FND_MESSAGE.Set_Name('CSI', 'CSI_API_OBJ_VER_MISMATCH');
4399: FND_MSG_PUB.ADD;
4400: RAISE FND_API.G_EXC_ERROR;
4401: END IF;
4402: --
4403: IF get_curr_party_rec%NOTFOUND THEN

Line 4405: FND_MSG_PUB.ADD;

4401: END IF;
4402: --
4403: IF get_curr_party_rec%NOTFOUND THEN
4404: FND_MESSAGE.Set_Name('CSI', 'CSI_API_RECORD_LOCKED');
4405: FND_MSG_PUB.ADD;
4406: RAISE FND_API.G_EXC_ERROR;
4407: END IF;
4408: CLOSE get_curr_party_rec;
4409: -- Initialize all the parameters and call update_inst_party_relationship to expire the record

Line 4454: x_msg_data := FND_MSG_PUB.GET(

4450: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4451: l_msg_index := 1;
4452: l_msg_count := x_msg_count;
4453: WHILE l_msg_count > 0 LOOP
4454: x_msg_data := FND_MSG_PUB.GET(
4455: l_msg_index,
4456: FND_API.G_FALSE );
4457: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
4458: l_msg_index := l_msg_index + 1;

Line 4471: FND_MSG_PUB.Count_And_Get

4467: IF FND_API.To_Boolean( p_commit ) THEN
4468: COMMIT WORK;
4469: END IF;
4470: -- Standard call to get message count and if count is get message info.
4471: FND_MSG_PUB.Count_And_Get
4472: (p_count => x_msg_count ,
4473: p_data => x_msg_data );
4474: EXCEPTION
4475: WHEN FND_API.G_EXC_ERROR THEN

Line 4478: FND_MSG_PUB.Count_And_Get

4474: EXCEPTION
4475: WHEN FND_API.G_EXC_ERROR THEN
4476: -- ROLLBACK TO expire_inst_party_rel_pvt;
4477: x_return_status := FND_API.G_RET_STS_ERROR ;
4478: FND_MSG_PUB.Count_And_Get
4479: ( p_count => x_msg_count,
4480: p_data => x_msg_data );
4481: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4482: -- ROLLBACK TO expire_inst_party_rel_pvt;

Line 4484: FND_MSG_PUB.Count_And_Get

4480: p_data => x_msg_data );
4481: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4482: -- ROLLBACK TO expire_inst_party_rel_pvt;
4483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4484: FND_MSG_PUB.Count_And_Get
4485: ( p_count => x_msg_count,
4486: p_data => x_msg_data );
4487: WHEN OTHERS THEN
4488: -- ROLLBACK TO expire_inst_party_rel_pvt;

Line 4490: IF FND_MSG_PUB.Check_Msg_Level

4486: p_data => x_msg_data );
4487: WHEN OTHERS THEN
4488: -- ROLLBACK TO expire_inst_party_rel_pvt;
4489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4490: IF FND_MSG_PUB.Check_Msg_Level
4491: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4492: THEN
4493: FND_MSG_PUB.Add_Exc_Msg
4494: ( g_pkg_name, l_api_name );

Line 4491: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4487: WHEN OTHERS THEN
4488: -- ROLLBACK TO expire_inst_party_rel_pvt;
4489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4490: IF FND_MSG_PUB.Check_Msg_Level
4491: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4492: THEN
4493: FND_MSG_PUB.Add_Exc_Msg
4494: ( g_pkg_name, l_api_name );
4495: END IF;

Line 4493: FND_MSG_PUB.Add_Exc_Msg

4489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4490: IF FND_MSG_PUB.Check_Msg_Level
4491: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4492: THEN
4493: FND_MSG_PUB.Add_Exc_Msg
4494: ( g_pkg_name, l_api_name );
4495: END IF;
4496: FND_MSG_PUB.Count_And_Get
4497: ( p_count => x_msg_count,

Line 4496: FND_MSG_PUB.Count_And_Get

4492: THEN
4493: FND_MSG_PUB.Add_Exc_Msg
4494: ( g_pkg_name, l_api_name );
4495: END IF;
4496: FND_MSG_PUB.Count_And_Get
4497: ( p_count => x_msg_count,
4498: p_data => x_msg_data );
4499: END expire_inst_party_relationship;
4500:

Line 4567: FND_MSG_PUB.initialize;

4563: END IF;
4564:
4565: -- Initialize message list if p_init_msg_list is set to TRUE.
4566: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4567: FND_MSG_PUB.initialize;
4568: END IF;
4569:
4570: -- Initialize API return status to success
4571: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4695: x_msg_data := FND_MSG_PUB.GET(

4691: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4692: l_msg_index := 1;
4693: l_msg_count := x_msg_count;
4694: WHILE l_msg_count > 0 LOOP
4695: x_msg_data := FND_MSG_PUB.GET(
4696: l_msg_index,
4697: FND_API.G_FALSE );
4698: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
4699: l_msg_index := l_msg_index + 1;

Line 4766: x_msg_data := FND_MSG_PUB.GET(

4762: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4763: l_msg_index := 1;
4764: l_msg_count := x_msg_count;
4765: WHILE l_msg_count > 0 LOOP
4766: x_msg_data := FND_MSG_PUB.GET(
4767: l_msg_index,
4768: FND_API.G_FALSE );
4769: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
4770: l_msg_index := l_msg_index + 1;

Line 4824: FND_MSG_PUB.Add;

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

Line 4842: -- FND_MSG_PUB.Add;

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

Line 4879: FND_MSG_PUB.Add;

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

Line 4945: FND_MSG_PUB.Add;

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

Line 4985: FND_MSG_PUB.Add;

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

Line 5089: x_msg_data := FND_MSG_PUB.GET(

5085: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5086: l_msg_index := 1;
5087: l_msg_count := x_msg_count;
5088: WHILE l_msg_count > 0 LOOP
5089: x_msg_data := FND_MSG_PUB.GET(
5090: l_msg_index,
5091: FND_API.G_FALSE );
5092: csi_gen_utility_pvt.put_line( 'message data = '||x_msg_data);
5093: l_msg_index := l_msg_index + 1;

Line 5211: x_msg_data := FND_MSG_PUB.GET(

5207: THEN
5208: l_msg_index := 1;
5209: l_msg_count := x_msg_count;
5210: WHILE l_msg_count > 0 LOOP
5211: x_msg_data := FND_MSG_PUB.GET(
5212: l_msg_index,
5213: FND_API.G_FALSE );
5214: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
5215: l_msg_index := l_msg_index + 1;

Line 5235: FND_MSG_PUB.Count_And_Get

5231: END IF;
5232:
5233:
5234: -- Standard call to get message count and if count is get message info.
5235: FND_MSG_PUB.Count_And_Get
5236: (p_count => x_msg_count ,
5237: p_data => x_msg_data );
5238: EXCEPTION
5239: WHEN FND_API.G_EXC_ERROR THEN

Line 5243: FND_MSG_PUB.Count_And_Get

5239: WHEN FND_API.G_EXC_ERROR THEN
5240: ROLLBACK TO create_inst_party_acct_pvt;
5241: x_return_status := FND_API.G_RET_STS_ERROR ;
5242:
5243: FND_MSG_PUB.Count_And_Get
5244: ( p_count => x_msg_count,
5245: p_data => x_msg_data );
5246: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5247: ROLLBACK TO create_inst_party_acct_pvt;

Line 5249: FND_MSG_PUB.Count_And_Get

5245: p_data => x_msg_data );
5246: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5247: ROLLBACK TO create_inst_party_acct_pvt;
5248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5249: FND_MSG_PUB.Count_And_Get
5250: ( p_count => x_msg_count,
5251: p_data => x_msg_data );
5252: WHEN OTHERS THEN
5253: ROLLBACK TO create_inst_party_acct_pvt;

Line 5255: IF FND_MSG_PUB.Check_Msg_Level

5251: p_data => x_msg_data );
5252: WHEN OTHERS THEN
5253: ROLLBACK TO create_inst_party_acct_pvt;
5254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5255: IF FND_MSG_PUB.Check_Msg_Level
5256: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5257: THEN
5258: FND_MSG_PUB.Add_Exc_Msg
5259: ( g_pkg_name, l_api_name );

Line 5256: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5252: WHEN OTHERS THEN
5253: ROLLBACK TO create_inst_party_acct_pvt;
5254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5255: IF FND_MSG_PUB.Check_Msg_Level
5256: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5257: THEN
5258: FND_MSG_PUB.Add_Exc_Msg
5259: ( g_pkg_name, l_api_name );
5260: END IF;

Line 5258: FND_MSG_PUB.Add_Exc_Msg

5254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5255: IF FND_MSG_PUB.Check_Msg_Level
5256: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5257: THEN
5258: FND_MSG_PUB.Add_Exc_Msg
5259: ( g_pkg_name, l_api_name );
5260: END IF;
5261: FND_MSG_PUB.Count_And_Get
5262: ( p_count => x_msg_count,

Line 5261: FND_MSG_PUB.Count_And_Get

5257: THEN
5258: FND_MSG_PUB.Add_Exc_Msg
5259: ( g_pkg_name, l_api_name );
5260: END IF;
5261: FND_MSG_PUB.Count_And_Get
5262: ( p_count => x_msg_count,
5263: p_data => x_msg_data );
5264:
5265: END create_inst_party_account;

Line 5440: FND_MSG_PUB.initialize;

5436: END IF;
5437:
5438: -- Initialize message list if p_init_msg_list is set to TRUE.
5439: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5440: FND_MSG_PUB.initialize;
5441: END IF;
5442:
5443: -- Initialize API return status to success
5444: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5475: FND_MSG_PUB.Add;

5471: l_api_name );
5472: --
5473: IF p_party_account_rec.party_account_id IS NULL THEN
5474: FND_MESSAGE.SET_NAME('CSI','CSI_API_MANDATORY_ACCOUNT');
5475: FND_MSG_PUB.Add;
5476: RAISE FND_API.G_EXC_ERROR;
5477: END IF;
5478: --
5479: -- Check if the instance party id is valid

Line 5489: FND_MSG_PUB.ADD;

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

Line 5494: FND_MSG_PUB.ADD;

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

Line 5521: -- FND_MSG_PUB.Add;

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

Line 5530: FND_MSG_PUB.ADD;

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

Line 5549: FND_MSG_PUB.ADD;

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

Line 5578: FND_MSG_PUB.ADD;

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

Line 5586: FND_MSG_PUB.ADD;

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

Line 5605: FND_MSG_PUB.ADD;

5601: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
5602: --
5603: IF l_internal_party_id IS NULL THEN
5604: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
5605: FND_MSG_PUB.ADD;
5606: RAISE FND_API.G_EXC_ERROR;
5607: END IF;
5608: --
5609: -- End addition by sguthiva for bug 2307804

Line 5615: FND_MSG_PUB.ADD;

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

Line 5643: FND_MSG_PUB.ADD;

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

Line 5661: FND_MSG_PUB.ADD;

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

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

5900:
5901: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5902:
5903: FOR i in 1..x_msg_Count LOOP
5904: FND_MSG_PUB.Get(p_msg_index => i,
5905: p_encoded => 'F',
5906: p_data => x_msg_data,
5907: p_msg_index_out => x_msg_index_out );
5908: csi_gen_utility_pvt.put_line( 'message data = '||x_msg_data);

Line 5927: FND_MSG_PUB.ADD;

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

Line 6884: FND_MSG_PUB.ADD;

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

Line 6980: x_msg_data := FND_MSG_PUB.GET(

6976: csi_gen_utility_pvt.put_line('Cascade Ownership - Call to contracts with TRM txn type has errored ');
6977: l_msg_index := 1;
6978: l_msg_count := x_msg_count;
6979: WHILE l_msg_count > 0 LOOP
6980: x_msg_data := FND_MSG_PUB.GET(
6981: l_msg_index,
6982: FND_API.G_FALSE );
6983: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
6984: l_msg_index := l_msg_index + 1;

Line 7013: x_msg_data := FND_MSG_PUB.GET(

7009: csi_gen_utility_pvt.put_line('Cascade Ownership - Call to contracts with NEW txn type has errored ');
7010: l_msg_index := 1;
7011: l_msg_count := x_msg_count;
7012: WHILE l_msg_count > 0 LOOP
7013: x_msg_data := FND_MSG_PUB.GET(
7014: l_msg_index,
7015: FND_API.G_FALSE );
7016: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
7017: l_msg_index := l_msg_index + 1;

Line 7066: x_msg_data := FND_MSG_PUB.GET(

7062: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
7063: l_msg_index := 1;
7064: l_msg_count := x_msg_count;
7065: WHILE l_msg_count > 0 LOOP
7066: x_msg_data := FND_MSG_PUB.GET(
7067: l_msg_index,
7068: FND_API.G_FALSE );
7069: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
7070: l_msg_index := l_msg_index + 1;

Line 7085: FND_MSG_PUB.Count_And_Get

7081: IF FND_API.To_Boolean( p_commit ) THEN
7082: COMMIT WORK;
7083: END IF;
7084: -- Standard call to get message count and if count is get message info.
7085: FND_MSG_PUB.Count_And_Get
7086: (p_count => x_msg_count ,
7087: p_data => x_msg_data );
7088: EXCEPTION
7089: WHEN FND_API.G_EXC_ERROR THEN

Line 7092: FND_MSG_PUB.Count_And_Get

7088: EXCEPTION
7089: WHEN FND_API.G_EXC_ERROR THEN
7090: -- ROLLBACK TO update_inst_party_acct_pvt;
7091: x_return_status := FND_API.G_RET_STS_ERROR ;
7092: FND_MSG_PUB.Count_And_Get
7093: ( p_count => x_msg_count,
7094: p_data => x_msg_data );
7095: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7096: -- ROLLBACK TO update_inst_party_acct_pvt;

Line 7098: FND_MSG_PUB.Count_And_Get

7094: p_data => x_msg_data );
7095: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7096: -- ROLLBACK TO update_inst_party_acct_pvt;
7097: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7098: FND_MSG_PUB.Count_And_Get
7099: ( p_count => x_msg_count,
7100: p_data => x_msg_data );
7101: WHEN OTHERS THEN
7102: -- ROLLBACK TO update_inst_party_acct_pvt;

Line 7104: IF FND_MSG_PUB.Check_Msg_Level

7100: p_data => x_msg_data );
7101: WHEN OTHERS THEN
7102: -- ROLLBACK TO update_inst_party_acct_pvt;
7103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7104: IF FND_MSG_PUB.Check_Msg_Level
7105: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7106: THEN
7107: FND_MSG_PUB.Add_Exc_Msg
7108: ( g_pkg_name, l_api_name );

Line 7105: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

7101: WHEN OTHERS THEN
7102: -- ROLLBACK TO update_inst_party_acct_pvt;
7103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7104: IF FND_MSG_PUB.Check_Msg_Level
7105: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7106: THEN
7107: FND_MSG_PUB.Add_Exc_Msg
7108: ( g_pkg_name, l_api_name );
7109: END IF;

Line 7107: FND_MSG_PUB.Add_Exc_Msg

7103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7104: IF FND_MSG_PUB.Check_Msg_Level
7105: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7106: THEN
7107: FND_MSG_PUB.Add_Exc_Msg
7108: ( g_pkg_name, l_api_name );
7109: END IF;
7110: FND_MSG_PUB.Count_And_Get
7111: ( p_count => x_msg_count,

Line 7110: FND_MSG_PUB.Count_And_Get

7106: THEN
7107: FND_MSG_PUB.Add_Exc_Msg
7108: ( g_pkg_name, l_api_name );
7109: END IF;
7110: FND_MSG_PUB.Count_And_Get
7111: ( p_count => x_msg_count,
7112: p_data => x_msg_data );
7113: END update_inst_party_account ;
7114:

Line 7200: FND_MSG_PUB.initialize;

7196: END IF;
7197:
7198: -- Initialize message list if p_init_msg_list is set to TRUE.
7199: IF FND_API.to_Boolean( p_init_msg_list ) THEN
7200: FND_MSG_PUB.initialize;
7201: END IF;
7202:
7203: -- Initialize API return status to success
7204: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 7245: FND_MSG_PUB.Add;

7241: IF NOT(CSI_Instance_parties_vld_pvt.Is_Ip_account_Valid
7242: (p_party_account_rec.ip_account_id))THEN
7243: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_IP_ACCOUNT_ID');
7244: FND_MESSAGE.SET_TOKEN('IP_ACCOUNT_ID',p_party_account_rec.ip_account_id);
7245: FND_MSG_PUB.Add;
7246: RAISE FND_API.G_EXC_ERROR;
7247: END IF;
7248: -- check if the object_version_number passed matches with the one
7249: -- in the database else raise error

Line 7255: FND_MSG_PUB.ADD;

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

Line 7261: FND_MSG_PUB.ADD;

7257: END IF;
7258: --
7259: IF get_curr_party_acct_rec%NOTFOUND THEN
7260: FND_MESSAGE.Set_Name('CSI', 'CSI_API_RECORD_LOCKED');
7261: FND_MSG_PUB.ADD;
7262: RAISE FND_API.G_EXC_ERROR;
7263: END IF;
7264: CLOSE get_curr_party_acct_rec;
7265: -- Initialize all the parameters and call upate_inst_party_account to expire the record

Line 7320: x_msg_data := FND_MSG_PUB.GET(

7316: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
7317: l_msg_index := 1;
7318: l_msg_count := x_msg_count;
7319: WHILE l_msg_count > 0 LOOP
7320: x_msg_data := FND_MSG_PUB.GET(
7321: l_msg_index,
7322: FND_API.G_FALSE );
7323: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
7324: l_msg_index := l_msg_index + 1;

Line 7338: FND_MSG_PUB.Count_And_Get

7334: IF FND_API.To_Boolean( p_commit ) THEN
7335: COMMIT WORK;
7336: END IF;
7337: -- Standard call to get message count and if count is get message info.
7338: FND_MSG_PUB.Count_And_Get
7339: (p_count => x_msg_count ,
7340: p_data => x_msg_data );
7341: EXCEPTION
7342: WHEN FND_API.G_EXC_ERROR THEN

Line 7345: FND_MSG_PUB.Count_And_Get

7341: EXCEPTION
7342: WHEN FND_API.G_EXC_ERROR THEN
7343: ROLLBACK TO expire_inst_party_acct_pvt;
7344: x_return_status := FND_API.G_RET_STS_ERROR ;
7345: FND_MSG_PUB.Count_And_Get
7346: ( p_count => x_msg_count,
7347: p_data => x_msg_data );
7348:
7349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 7352: FND_MSG_PUB.Count_And_Get

7348:
7349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7350: ROLLBACK TO expire_inst_party_acct_pvt;
7351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7352: FND_MSG_PUB.Count_And_Get
7353: ( p_count => x_msg_count,
7354: p_data => x_msg_data );
7355: WHEN OTHERS THEN
7356: ROLLBACK TO expire_inst_party_acct_pvt;

Line 7358: IF FND_MSG_PUB.Check_Msg_Level

7354: p_data => x_msg_data );
7355: WHEN OTHERS THEN
7356: ROLLBACK TO expire_inst_party_acct_pvt;
7357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7358: IF FND_MSG_PUB.Check_Msg_Level
7359: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7360: THEN
7361: FND_MSG_PUB.Add_Exc_Msg
7362: ( g_pkg_name, l_api_name );

Line 7359: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

7355: WHEN OTHERS THEN
7356: ROLLBACK TO expire_inst_party_acct_pvt;
7357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7358: IF FND_MSG_PUB.Check_Msg_Level
7359: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7360: THEN
7361: FND_MSG_PUB.Add_Exc_Msg
7362: ( g_pkg_name, l_api_name );
7363: END IF;

Line 7361: FND_MSG_PUB.Add_Exc_Msg

7357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7358: IF FND_MSG_PUB.Check_Msg_Level
7359: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7360: THEN
7361: FND_MSG_PUB.Add_Exc_Msg
7362: ( g_pkg_name, l_api_name );
7363: END IF;
7364: FND_MSG_PUB.Count_And_Get
7365: ( p_count => x_msg_count,

Line 7364: FND_MSG_PUB.Count_And_Get

7360: THEN
7361: FND_MSG_PUB.Add_Exc_Msg
7362: ( g_pkg_name, l_api_name );
7363: END IF;
7364: FND_MSG_PUB.Count_And_Get
7365: ( p_count => x_msg_count,
7366: p_data => x_msg_data );
7367: END expire_inst_party_account ;
7368:

Line 7410: FND_MSG_PUB.initialize;

7406: END IF;
7407:
7408: -- Initialize message list if p_init_msg_list is set to TRUE.
7409: IF FND_API.to_Boolean( p_init_msg_list ) THEN
7410: FND_MSG_PUB.initialize;
7411: END IF;
7412:
7413: -- Initialize API return status to success
7414: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 7432: fnd_msg_pub.add;

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

Line 7761: FND_MSG_PUB.Count_And_Get

7757: END IF;
7758: */
7759:
7760: -- Standard call to get message count and if count is get message info.
7761: FND_MSG_PUB.Count_And_Get
7762: (p_count => x_msg_count ,
7763: p_data => x_msg_data );
7764: EXCEPTION
7765: WHEN FND_API.G_EXC_ERROR THEN

Line 7768: FND_MSG_PUB.Count_And_Get

7764: EXCEPTION
7765: WHEN FND_API.G_EXC_ERROR THEN
7766: -- ROLLBACK TO get_contact_details_pvt;
7767: x_return_status := FND_API.G_RET_STS_ERROR ;
7768: FND_MSG_PUB.Count_And_Get
7769: ( p_count => x_msg_count,
7770: p_data => x_msg_data );
7771: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7772: -- ROLLBACK TO get_contact_details_pvt;

Line 7774: FND_MSG_PUB.Count_And_Get

7770: p_data => x_msg_data );
7771: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7772: -- ROLLBACK TO get_contact_details_pvt;
7773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7774: FND_MSG_PUB.Count_And_Get
7775: ( p_count => x_msg_count,
7776: p_data => x_msg_data );
7777: WHEN OTHERS THEN
7778: -- ROLLBACK TO get_contact_details_pvt;

Line 7780: IF FND_MSG_PUB.Check_Msg_Level

7776: p_data => x_msg_data );
7777: WHEN OTHERS THEN
7778: -- ROLLBACK TO get_contact_details_pvt;
7779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7780: IF FND_MSG_PUB.Check_Msg_Level
7781: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7782: THEN
7783: FND_MSG_PUB.Add_Exc_Msg
7784: ( g_pkg_name, l_api_name );

Line 7781: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

7777: WHEN OTHERS THEN
7778: -- ROLLBACK TO get_contact_details_pvt;
7779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7780: IF FND_MSG_PUB.Check_Msg_Level
7781: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7782: THEN
7783: FND_MSG_PUB.Add_Exc_Msg
7784: ( g_pkg_name, l_api_name );
7785: END IF;

Line 7783: FND_MSG_PUB.Add_Exc_Msg

7779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7780: IF FND_MSG_PUB.Check_Msg_Level
7781: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7782: THEN
7783: FND_MSG_PUB.Add_Exc_Msg
7784: ( g_pkg_name, l_api_name );
7785: END IF;
7786: FND_MSG_PUB.Count_And_Get
7787: ( p_count => x_msg_count,

Line 7786: FND_MSG_PUB.Count_And_Get

7782: THEN
7783: FND_MSG_PUB.Add_Exc_Msg
7784: ( g_pkg_name, l_api_name );
7785: END IF;
7786: FND_MSG_PUB.Count_And_Get
7787: ( p_count => x_msg_count,
7788: p_data => x_msg_data );
7789:
7790: END get_contact_details ;

Line 7915: FND_MSG_PUB.initialize;

7911: END IF;
7912:
7913: -- Initialize message list if p_init_msg_list is set to TRUE.
7914: IF FND_API.to_Boolean( p_init_msg_list ) THEN
7915: FND_MSG_PUB.initialize;
7916: END IF;
7917:
7918: -- Initialize API return status to success
7919: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

8094:
8095:
8096: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
8097: FOR i in 1..x_msg_Count LOOP
8098: FND_MSG_PUB.Get(p_msg_index => i,
8099: p_encoded => 'F',
8100: p_data => x_msg_data,
8101: p_msg_index_out => x_msg_index_out );
8102: csi_gen_utility_pvt.put_line( 'message data = '||x_msg_data);

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

8286:
8287:
8288: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
8289: FOR i in 1..x_msg_Count LOOP
8290: FND_MSG_PUB.Get(p_msg_index => i,
8291: p_encoded => 'F',
8292: p_data => x_msg_data,
8293: p_msg_index_out => x_msg_index_out );
8294: csi_gen_utility_pvt.put_line( 'message data = '||x_msg_data);

Line 8475: --FND_MSG_PUB.Add;

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

Line 8498: FND_MSG_PUB.Count_And_Get

8494: -- End disable trace
8495: ****/
8496:
8497: -- Standard call to get message count and if count is get message info.
8498: FND_MSG_PUB.Count_And_Get
8499: (p_count => x_msg_count ,
8500: p_data => x_msg_data );
8501: EXCEPTION
8502: WHEN FND_API.G_EXC_ERROR THEN

Line 8505: FND_MSG_PUB.Count_And_Get

8501: EXCEPTION
8502: WHEN FND_API.G_EXC_ERROR THEN
8503: -- ROLLBACK TO get_inst_party_rel_hist;
8504: x_return_status := FND_API.G_RET_STS_ERROR ;
8505: FND_MSG_PUB.Count_And_Get
8506: ( p_count => x_msg_count,
8507: p_data => x_msg_data );
8508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8509: -- ROLLBACK TO get_inst_party_rel_hist;

Line 8511: FND_MSG_PUB.Count_And_Get

8507: p_data => x_msg_data );
8508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8509: -- ROLLBACK TO get_inst_party_rel_hist;
8510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8511: FND_MSG_PUB.Count_And_Get
8512: ( p_count => x_msg_count,
8513: p_data => x_msg_data );
8514: WHEN OTHERS THEN
8515: -- ROLLBACK TO get_inst_party_rel_hist;

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

8513: p_data => x_msg_data );
8514: WHEN OTHERS THEN
8515: -- ROLLBACK TO get_inst_party_rel_hist;
8516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8517: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8518: FND_MSG_PUB.Add_Exc_Msg
8519: ( g_pkg_name ,
8520: l_api_name );
8521: END IF;

Line 8518: FND_MSG_PUB.Add_Exc_Msg

8514: WHEN OTHERS THEN
8515: -- ROLLBACK TO get_inst_party_rel_hist;
8516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8517: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8518: FND_MSG_PUB.Add_Exc_Msg
8519: ( g_pkg_name ,
8520: l_api_name );
8521: END IF;
8522: FND_MSG_PUB.Count_And_Get

Line 8522: FND_MSG_PUB.Count_And_Get

8518: FND_MSG_PUB.Add_Exc_Msg
8519: ( g_pkg_name ,
8520: l_api_name );
8521: END IF;
8522: FND_MSG_PUB.Count_And_Get
8523: ( p_count => x_msg_count,
8524: p_data => x_msg_data );
8525:
8526: END get_inst_party_rel_hist;

Line 8636: FND_MSG_PUB.initialize;

8632: END IF;
8633:
8634: -- Initialize message list if p_init_msg_list is set to TRUE.
8635: IF FND_API.to_Boolean( p_init_msg_list ) THEN
8636: FND_MSG_PUB.initialize;
8637: END IF;
8638:
8639: -- Initialize API return status to success
8640: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 9059: FND_MSG_PUB.Count_And_Get

9055: -- End disable trace
9056: ****/
9057:
9058: -- Standard call to get message count and if count is get message info.
9059: FND_MSG_PUB.Count_And_Get
9060: (p_count => x_msg_count ,
9061: p_data => x_msg_data );
9062: EXCEPTION
9063: WHEN FND_API.G_EXC_ERROR THEN

Line 9066: FND_MSG_PUB.Count_And_Get

9062: EXCEPTION
9063: WHEN FND_API.G_EXC_ERROR THEN
9064: -- ROLLBACK TO get_inst_party_account_hist;
9065: x_return_status := FND_API.G_RET_STS_ERROR ;
9066: FND_MSG_PUB.Count_And_Get
9067: ( p_count => x_msg_count,
9068: p_data => x_msg_data );
9069: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9070: -- ROLLBACK TO get_inst_party_account_hist;

Line 9072: FND_MSG_PUB.Count_And_Get

9068: p_data => x_msg_data );
9069: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9070: -- ROLLBACK TO get_inst_party_account_hist;
9071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9072: FND_MSG_PUB.Count_And_Get
9073: ( p_count => x_msg_count,
9074: p_data => x_msg_data );
9075: WHEN OTHERS THEN
9076: -- ROLLBACK TO get_inst_party_account_hist;

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

9074: p_data => x_msg_data );
9075: WHEN OTHERS THEN
9076: -- ROLLBACK TO get_inst_party_account_hist;
9077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9078: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9079: FND_MSG_PUB.Add_Exc_Msg
9080: ( g_pkg_name ,
9081: l_api_name );
9082: END IF;

Line 9079: FND_MSG_PUB.Add_Exc_Msg

9075: WHEN OTHERS THEN
9076: -- ROLLBACK TO get_inst_party_account_hist;
9077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9078: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9079: FND_MSG_PUB.Add_Exc_Msg
9080: ( g_pkg_name ,
9081: l_api_name );
9082: END IF;
9083: FND_MSG_PUB.Count_And_Get

Line 9083: FND_MSG_PUB.Count_And_Get

9079: FND_MSG_PUB.Add_Exc_Msg
9080: ( g_pkg_name ,
9081: l_api_name );
9082: END IF;
9083: FND_MSG_PUB.Count_And_Get
9084: ( p_count => x_msg_count,
9085: p_data => x_msg_data );
9086:
9087: END get_inst_party_account_hist;