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_PUB dependencies on FND_MSG_PUB

Line 69: FND_MSG_PUB.initialize;

65: END IF;
66:
67: -- Initialize message list if p_init_msg_list is set to TRUE.
68: IF FND_API.to_Boolean( p_init_msg_list ) THEN
69: FND_MSG_PUB.initialize;
70: END IF;
71:
72: -- Initialize API return status to success
73: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 110: FND_MSG_PUB.Add;

106: AND (p_party_query_rec.party_id = FND_API.G_MISS_NUM)
107: AND (p_party_query_rec.relationship_type_code = FND_API.G_MISS_CHAR) THEN
108:
109: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_PARAMETERS');
110: FND_MSG_PUB.Add;
111: RAISE FND_API.G_EXC_ERROR;
112: END IF;
113:
114: -- Generate the where clause dynamically

Line 156: FND_MSG_PUB.ADD;

152: -- is < than sysdate
153: csi_party_relationships_pvt.Construct_pty_from_hist(x_party_header_tbl, p_time_stamp);
154: ELSE
155: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_HIST_PARAMS');
156: FND_MSG_PUB.ADD;
157: RAISE FND_API.G_EXC_ERROR;
158: END IF;
159: END IF;
160: --start of the new code for resolve_id_columns 08/24/01

Line 323: FND_MSG_PUB.Count_And_Get

319: -- End disable trace
320: ****/
321:
322: -- Standard call to get message count and if count is get message info.
323: FND_MSG_PUB.Count_And_Get
324: (p_count => x_msg_count ,
325: p_data => x_msg_data );
326: EXCEPTION
327: WHEN FND_API.G_EXC_ERROR THEN

Line 330: FND_MSG_PUB.Count_And_Get

326: EXCEPTION
327: WHEN FND_API.G_EXC_ERROR THEN
328: -- ROLLBACK TO get_inst_party_rel_pub;
329: x_return_status := FND_API.G_RET_STS_ERROR ;
330: FND_MSG_PUB.Count_And_Get
331: ( p_count => x_msg_count,
332: p_data => x_msg_data );
333: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
334: -- ROLLBACK TO get_inst_party_rel_pub;

Line 336: FND_MSG_PUB.Count_And_Get

332: p_data => x_msg_data );
333: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
334: -- ROLLBACK TO get_inst_party_rel_pub;
335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
336: FND_MSG_PUB.Count_And_Get
337: ( p_count => x_msg_count,
338: p_data => x_msg_data );
339: WHEN OTHERS THEN
340: IF DBMS_SQL.IS_OPEN(l_get_party_cursor_id) THEN

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

341: DBMS_SQL.CLOSE_CURSOR(l_get_party_cursor_id);
342: END IF;
343: -- ROLLBACK TO get_inst_party_rel_pub;
344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
345: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
346: FND_MSG_PUB.Add_Exc_Msg
347: ( g_pkg_name ,
348: l_api_name );
349: END IF;

Line 346: FND_MSG_PUB.Add_Exc_Msg

342: END IF;
343: -- ROLLBACK TO get_inst_party_rel_pub;
344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
345: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
346: FND_MSG_PUB.Add_Exc_Msg
347: ( g_pkg_name ,
348: l_api_name );
349: END IF;
350: FND_MSG_PUB.Count_And_Get

Line 350: FND_MSG_PUB.Count_And_Get

346: FND_MSG_PUB.Add_Exc_Msg
347: ( g_pkg_name ,
348: l_api_name );
349: END IF;
350: FND_MSG_PUB.Count_And_Get
351: ( p_count => x_msg_count,
352: p_data => x_msg_data );
353:
354: END get_inst_party_relationships;

Line 414: FND_MSG_PUB.initialize;

410: END IF;
411:
412: -- Initialize message list if p_init_msg_list is set to TRUE.
413: IF FND_API.to_Boolean( p_init_msg_list ) THEN
414: FND_MSG_PUB.initialize;
415: END IF;
416:
417: -- Initialize API return status to success
418: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 459: FND_MSG_PUB.ADD;

455: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
456: --
457: IF l_internal_party_id IS NULL THEN
458: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
459: FND_MSG_PUB.ADD;
460: RAISE FND_API.G_EXC_ERROR;
461: END IF;
462: -- Check if the table is not empty and then loop
463: IF p_party_tbl.count > 0 THEN

Line 483: FND_MSG_PUB.Add;

479: OR (p_party_account_tbl(l_acct_row).parent_tbl_index = FND_API.G_MISS_NUM)
480: OR (NOT(p_party_tbl.EXISTS(p_party_account_tbl(l_acct_row).parent_tbl_index)))
481: ) THEN
482: FND_MESSAGE.SET_NAME('CSI','CSI_API_PARTY_ACCT_NOT_MAPPED');
483: FND_MSG_PUB.Add;
484: RAISE FND_API.G_EXC_ERROR;
485: END IF;
486:
487: IF ((p_party_account_tbl(l_acct_row).parent_tbl_index = l_party_row)

Line 499: FND_MSG_PUB.ADD;

495: -- Raise an exception if external parties don't have an owner account
496: IF NOT l_party_has_correct_acct THEN
497: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_OWNER_ACCT');
498: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_tbl(l_party_row).party_id);
499: FND_MSG_PUB.ADD;
500: RAISE FND_API.G_EXC_ERROR;
501: END IF;
502:
503: END IF;

Line 545: x_msg_data := FND_MSG_PUB.GET

541: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
542: l_msg_index := 1;
543: l_msg_count := x_msg_count;
544: WHILE l_msg_count > 0 LOOP
545: x_msg_data := FND_MSG_PUB.GET
546: ( l_msg_index,
547: FND_API.G_FALSE );
548: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
549: l_msg_index := l_msg_index + 1;

Line 567: FND_MSG_PUB.Add;

563: OR (p_party_account_tbl(l_acct_row).parent_tbl_index = FND_API.G_MISS_NUM)
564: OR (NOT(p_party_tbl.EXISTS(p_party_account_tbl(l_acct_row).parent_tbl_index)))
565: ) THEN
566: FND_MESSAGE.SET_NAME('CSI','CSI_API_PARTY_ACCT_NOT_MAPPED');
567: FND_MSG_PUB.Add;
568: RAISE FND_API.G_EXC_ERROR;
569: END IF;
570:
571: p_party_account_tbl(l_acct_row).instance_party_id :=

Line 637: x_msg_data := FND_MSG_PUB.GET(

633: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
634: l_msg_index := 1;
635: l_msg_count := x_msg_count;
636: WHILE l_msg_count > 0 LOOP
637: x_msg_data := FND_MSG_PUB.GET(
638: l_msg_index,
639: FND_API.G_FALSE );
640: csi_gen_utility_pvt.put_line( 'message data = '||x_msg_data);
641: l_msg_index := l_msg_index + 1;

Line 668: FND_MSG_PUB.Count_And_Get

664: -- End disable trace
665: ****/
666:
667: -- Standard call to get message count and if count is get message info.
668: FND_MSG_PUB.Count_And_Get
669: (p_count => x_msg_count ,
670: p_data => x_msg_data );
671: EXCEPTION
672: WHEN FND_API.G_EXC_ERROR THEN

Line 675: FND_MSG_PUB.Count_And_Get

671: EXCEPTION
672: WHEN FND_API.G_EXC_ERROR THEN
673: x_return_status := FND_API.G_RET_STS_ERROR ;
674: ROLLBACK TO create_inst_party_rel_pub;
675: FND_MSG_PUB.Count_And_Get
676: ( p_count => x_msg_count,
677: p_data => x_msg_data );
678:
679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 682: FND_MSG_PUB.Count_And_Get

678:
679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
681: ROLLBACK TO create_inst_party_rel_pub;
682: FND_MSG_PUB.Count_And_Get
683: ( p_count => x_msg_count,
684: p_data => x_msg_data );
685:
686: WHEN OTHERS THEN

Line 689: IF FND_MSG_PUB.Check_Msg_Level

685:
686: WHEN OTHERS THEN
687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
688: ROLLBACK TO create_inst_party_rel_pub;
689: IF FND_MSG_PUB.Check_Msg_Level
690: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
691: THEN
692: FND_MSG_PUB.Add_Exc_Msg
693: ( g_pkg_name ,

Line 690: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

686: WHEN OTHERS THEN
687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
688: ROLLBACK TO create_inst_party_rel_pub;
689: IF FND_MSG_PUB.Check_Msg_Level
690: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
691: THEN
692: FND_MSG_PUB.Add_Exc_Msg
693: ( g_pkg_name ,
694: l_api_name );

Line 692: FND_MSG_PUB.Add_Exc_Msg

688: ROLLBACK TO create_inst_party_rel_pub;
689: IF FND_MSG_PUB.Check_Msg_Level
690: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
691: THEN
692: FND_MSG_PUB.Add_Exc_Msg
693: ( g_pkg_name ,
694: l_api_name );
695: END IF;
696: FND_MSG_PUB.Count_And_Get

Line 696: FND_MSG_PUB.Count_And_Get

692: FND_MSG_PUB.Add_Exc_Msg
693: ( g_pkg_name ,
694: l_api_name );
695: END IF;
696: FND_MSG_PUB.Count_And_Get
697: ( p_count => x_msg_count,
698: p_data => x_msg_data );
699: END create_inst_party_relationship;
700:

Line 848: FND_MSG_PUB.initialize;

844: END IF;
845:
846: -- Initialize message list if p_init_msg_list is set to TRUE.
847: IF FND_API.to_Boolean( p_init_msg_list ) THEN
848: FND_MSG_PUB.initialize;
849: END IF;
850:
851:
852: -- Initialize API return status to success

Line 951: FND_MSG_PUB.ADD;

947: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
948: --
949: IF l_internal_party_id IS NULL THEN
950: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
951: FND_MSG_PUB.ADD;
952: RAISE FND_API.G_EXC_ERROR;
953: END IF;
954: -- Check if the table is not empty
955: IF p_party_tbl.count > 0 THEN

Line 990: FND_MSG_PUB.Add;

986: OR (p_party_account_tbl(l_acct_row).parent_tbl_index = FND_API.G_MISS_NUM)
987: OR (NOT(p_party_tbl.EXISTS(p_party_account_tbl(l_acct_row).parent_tbl_index)))
988: ) THEN
989: FND_MESSAGE.SET_NAME('CSI','CSI_API_PARTY_ACCT_NOT_MAPPED');
990: FND_MSG_PUB.Add;
991: RAISE FND_API.G_EXC_ERROR;
992: END IF;
993:
994: IF ((p_party_account_tbl(l_acct_row).parent_tbl_index = l_party_row)

Line 1017: FND_MSG_PUB.ADD;

1013: -- Raise an exception if external parties don't have an owner account
1014: IF NOT l_party_has_correct_acct THEN
1015: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_OWNER_ACCT');
1016: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_tbl(l_party_row).party_id);
1017: FND_MSG_PUB.ADD;
1018: RAISE FND_API.G_EXC_ERROR;
1019: END IF;
1020:
1021: END IF;

Line 1115: x_msg_data := FND_MSG_PUB.GET(

1111: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1112: l_msg_index := 1;
1113: l_msg_count := x_msg_count;
1114: WHILE l_msg_count > 0 LOOP
1115: x_msg_data := FND_MSG_PUB.GET(
1116: l_msg_index,
1117: FND_API.G_FALSE );
1118: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
1119: l_msg_index := l_msg_index + 1;

Line 1228: x_msg_data := FND_MSG_PUB.GET(

1224: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1225: l_msg_index := 1;
1226: l_msg_count := x_msg_count;
1227: WHILE l_msg_count > 0 LOOP
1228: x_msg_data := FND_MSG_PUB.GET(
1229: l_msg_index,
1230: FND_API.G_FALSE );
1231: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
1232: l_msg_index := l_msg_index + 1;

Line 1297: x_msg_data := FND_MSG_PUB.GET(

1293: l_msg_index := 1;
1294: l_msg_count := x_msg_count;
1295: WHILE l_msg_count > 0
1296: LOOP
1297: x_msg_data := FND_MSG_PUB.GET(
1298: l_msg_index,
1299: FND_API.G_FALSE );
1300: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
1301: l_msg_index := l_msg_index + 1;

Line 1335: x_msg_data := FND_MSG_PUB.GET(

1331: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1332: l_msg_index := 1;
1333: l_msg_count := x_msg_count;
1334: WHILE l_msg_count > 0 LOOP
1335: x_msg_data := FND_MSG_PUB.GET(
1336: l_msg_index,
1337: FND_API.G_FALSE );
1338: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
1339: l_msg_index := l_msg_index + 1;

Line 1390: x_msg_data := FND_MSG_PUB.GET(

1386: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1387: l_msg_index := 1;
1388: l_msg_count := x_msg_count;
1389: WHILE l_msg_count > 0 LOOP
1390: x_msg_data := FND_MSG_PUB.GET(
1391: l_msg_index,
1392: FND_API.G_FALSE );
1393: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
1394: l_msg_index := l_msg_index + 1;

Line 1549: FND_MSG_PUB.Add;

1545: );
1546: --
1547: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1548: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_CHILDREN_ERROR');
1549: FND_MSG_PUB.Add;
1550: RAISE FND_API.G_EXC_ERROR;
1551: END IF;
1552: END IF;
1553: --

Line 1663: x_msg_data := FND_MSG_PUB.GET(

1659: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1660: l_msg_index := 1;
1661: l_msg_count := x_msg_count;
1662: WHILE l_msg_count > 0 LOOP
1663: x_msg_data := FND_MSG_PUB.GET(
1664: l_msg_index,
1665: FND_API.G_FALSE );
1666: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
1667: l_msg_index := l_msg_index + 1;

Line 1716: x_msg_data := FND_MSG_PUB.GET(

1712: l_msg_index := 1;
1713: l_msg_count := x_msg_count;
1714: WHILE l_msg_count > 0
1715: LOOP
1716: x_msg_data := FND_MSG_PUB.GET(
1717: l_msg_index,
1718: FND_API.G_FALSE );
1719: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
1720: l_msg_index := l_msg_index + 1;

Line 1774: x_msg_data := FND_MSG_PUB.GET(

1770: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1771: l_msg_index := 1;
1772: l_msg_count := x_msg_count;
1773: WHILE l_msg_count > 0 LOOP
1774: x_msg_data := FND_MSG_PUB.GET(
1775: l_msg_index,
1776: FND_API.G_FALSE );
1777: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
1778: l_msg_index := l_msg_index + 1;

Line 1849: x_msg_data := FND_MSG_PUB.GET(

1845: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1846: l_msg_index := 1;
1847: l_msg_count := x_msg_count;
1848: WHILE l_msg_count > 0 LOOP
1849: x_msg_data := FND_MSG_PUB.GET(
1850: l_msg_index,
1851: FND_API.G_FALSE );
1852: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
1853: l_msg_index := l_msg_index + 1;

Line 1891: FND_MSG_PUB.Count_And_Get

1887: -- End disable trace
1888: ****/
1889:
1890: -- Standard call to get message count and if count is get message info.
1891: FND_MSG_PUB.Count_And_Get
1892: (p_count => x_msg_count ,
1893: p_data => x_msg_data );
1894: EXCEPTION
1895: WHEN FND_API.G_EXC_ERROR THEN

Line 1898: FND_MSG_PUB.Count_And_Get

1894: EXCEPTION
1895: WHEN FND_API.G_EXC_ERROR THEN
1896: ROLLBACK TO update_inst_party_rel_pub;
1897: x_return_status := FND_API.G_RET_STS_ERROR ;
1898: FND_MSG_PUB.Count_And_Get
1899: ( p_count => x_msg_count,
1900: p_data => x_msg_data );
1901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1902: ROLLBACK TO update_inst_party_rel_pub;

Line 1904: FND_MSG_PUB.Count_And_Get

1900: p_data => x_msg_data );
1901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1902: ROLLBACK TO update_inst_party_rel_pub;
1903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1904: FND_MSG_PUB.Count_And_Get
1905: ( p_count => x_msg_count,
1906: p_data => x_msg_data );
1907: WHEN OTHERS THEN
1908: ROLLBACK TO update_inst_party_rel_pub;

Line 1910: IF FND_MSG_PUB.Check_Msg_Level

1906: p_data => x_msg_data );
1907: WHEN OTHERS THEN
1908: ROLLBACK TO update_inst_party_rel_pub;
1909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1910: IF FND_MSG_PUB.Check_Msg_Level
1911: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1912: THEN
1913: FND_MSG_PUB.Add_Exc_Msg
1914: ( g_pkg_name, l_api_name );

Line 1911: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1907: WHEN OTHERS THEN
1908: ROLLBACK TO update_inst_party_rel_pub;
1909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1910: IF FND_MSG_PUB.Check_Msg_Level
1911: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1912: THEN
1913: FND_MSG_PUB.Add_Exc_Msg
1914: ( g_pkg_name, l_api_name );
1915: END IF;

Line 1913: FND_MSG_PUB.Add_Exc_Msg

1909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1910: IF FND_MSG_PUB.Check_Msg_Level
1911: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1912: THEN
1913: FND_MSG_PUB.Add_Exc_Msg
1914: ( g_pkg_name, l_api_name );
1915: END IF;
1916: FND_MSG_PUB.Count_And_Get
1917: ( p_count => x_msg_count,

Line 1916: FND_MSG_PUB.Count_And_Get

1912: THEN
1913: FND_MSG_PUB.Add_Exc_Msg
1914: ( g_pkg_name, l_api_name );
1915: END IF;
1916: FND_MSG_PUB.Count_And_Get
1917: ( p_count => x_msg_count,
1918: p_data => x_msg_data );
1919: END update_inst_party_relationship ;
1920:

Line 1967: FND_MSG_PUB.initialize;

1963: END IF;
1964:
1965: -- Initialize message list if p_init_msg_list is set to TRUE.
1966: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1967: FND_MSG_PUB.initialize;
1968: END IF;
1969:
1970: -- Initialize API return status to success
1971: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2019: x_msg_data := FND_MSG_PUB.GET(

2015: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2016: l_msg_index := 1;
2017: l_msg_count := x_msg_count;
2018: WHILE l_msg_count > 0 LOOP
2019: x_msg_data := FND_MSG_PUB.GET(
2020: l_msg_index,
2021: FND_API.G_FALSE );
2022: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
2023: l_msg_index := l_msg_index + 1;

Line 2048: FND_MSG_PUB.Count_And_Get

2044: -- End disable trace
2045: ****/
2046:
2047: -- Standard call to get message count and if count is get message info.
2048: FND_MSG_PUB.Count_And_Get
2049: (p_count => x_msg_count ,
2050: p_data => x_msg_data );
2051: EXCEPTION
2052: WHEN FND_API.G_EXC_ERROR THEN

Line 2055: FND_MSG_PUB.Count_And_Get

2051: EXCEPTION
2052: WHEN FND_API.G_EXC_ERROR THEN
2053: ROLLBACK TO expire_inst_party_rel_pub;
2054: x_return_status := FND_API.G_RET_STS_ERROR ;
2055: FND_MSG_PUB.Count_And_Get
2056: ( p_count => x_msg_count,
2057: p_data => x_msg_data );
2058:
2059: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2062: FND_MSG_PUB.Count_And_Get

2058:
2059: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2060: ROLLBACK TO expire_inst_party_rel_pub;
2061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2062: FND_MSG_PUB.Count_And_Get
2063: ( p_count => x_msg_count,
2064: p_data => x_msg_data );
2065:
2066: WHEN OTHERS THEN

Line 2069: IF FND_MSG_PUB.Check_Msg_Level

2065:
2066: WHEN OTHERS THEN
2067: ROLLBACK TO expire_inst_party_relationship;
2068: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2069: IF FND_MSG_PUB.Check_Msg_Level
2070: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2071: THEN
2072: FND_MSG_PUB.Add_Exc_Msg
2073: ( g_pkg_name, l_api_name );

Line 2070: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2066: WHEN OTHERS THEN
2067: ROLLBACK TO expire_inst_party_relationship;
2068: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2069: IF FND_MSG_PUB.Check_Msg_Level
2070: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2071: THEN
2072: FND_MSG_PUB.Add_Exc_Msg
2073: ( g_pkg_name, l_api_name );
2074: END IF;

Line 2072: FND_MSG_PUB.Add_Exc_Msg

2068: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2069: IF FND_MSG_PUB.Check_Msg_Level
2070: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2071: THEN
2072: FND_MSG_PUB.Add_Exc_Msg
2073: ( g_pkg_name, l_api_name );
2074: END IF;
2075: FND_MSG_PUB.Count_And_Get
2076: ( p_count => x_msg_count,

Line 2075: FND_MSG_PUB.Count_And_Get

2071: THEN
2072: FND_MSG_PUB.Add_Exc_Msg
2073: ( g_pkg_name, l_api_name );
2074: END IF;
2075: FND_MSG_PUB.Count_And_Get
2076: ( p_count => x_msg_count,
2077: p_data => x_msg_data );
2078:
2079: END expire_inst_party_relationship;

Line 2142: FND_MSG_PUB.initialize;

2138: END IF;
2139:
2140: -- Initialize message list if p_init_msg_list is set to TRUE.
2141: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2142: FND_MSG_PUB.initialize;
2143: END IF;
2144:
2145: -- Initialize API return status to success
2146: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2184: FND_MSG_PUB.ADD;

2180: AND (p_account_query_rec.party_account_id = FND_API.G_MISS_NUM)
2181: AND (p_account_query_rec.relationship_type_code = FND_API.G_MISS_CHAR) THEN
2182:
2183: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_PARAMETERS');
2184: FND_MSG_PUB.ADD;
2185: RAISE FND_API.G_EXC_ERROR;
2186: END IF;
2187:
2188: -- Generate the where clause

Line 2227: FND_MSG_PUB.ADD;

2223: -- Contruct from the history if p_time_stamp is less than sysdate
2224: csi_party_relationships_pvt.Construct_acct_from_hist(x_account_header_tbl, p_time_stamp);
2225: ELSE
2226: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_HIST_PARAMS');
2227: FND_MSG_PUB.ADD;
2228: RAISE FND_API.G_EXC_ERROR;
2229: END IF;
2230: END IF;
2231:

Line 2261: FND_MSG_PUB.Count_And_Get

2257: -- End disable trace
2258: ****/
2259:
2260: -- Standard call to get message count and if count is get message info.
2261: FND_MSG_PUB.Count_And_Get
2262: (p_count => x_msg_count ,
2263: p_data => x_msg_data );
2264: EXCEPTION
2265: WHEN FND_API.G_EXC_ERROR THEN

Line 2268: FND_MSG_PUB.Count_And_Get

2264: EXCEPTION
2265: WHEN FND_API.G_EXC_ERROR THEN
2266: -- ROLLBACK TO get_inst_party_acct_pub;
2267: x_return_status := FND_API.G_RET_STS_ERROR ;
2268: FND_MSG_PUB.Count_And_Get
2269: ( p_count => x_msg_count,
2270: p_data => x_msg_data );
2271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2272: -- ROLLBACK TO get_inst_party_acct_pub;

Line 2274: FND_MSG_PUB.Count_And_Get

2270: p_data => x_msg_data );
2271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2272: -- ROLLBACK TO get_inst_party_acct_pub;
2273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2274: FND_MSG_PUB.Count_And_Get
2275: ( p_count => x_msg_count,
2276: p_data => x_msg_data );
2277: WHEN OTHERS THEN
2278: IF dbms_sql.is_open(l_get_acct_cursor_id) then

Line 2283: IF FND_MSG_PUB.Check_Msg_Level

2279: dbms_sql.close_cursor(l_get_acct_cursor_id);
2280: END IF;
2281: -- ROLLBACK TO get_inst_party_acct_pub;
2282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2283: IF FND_MSG_PUB.Check_Msg_Level
2284: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2285: THEN
2286: FND_MSG_PUB.Add_Exc_Msg
2287: ( g_pkg_name, l_api_name );

Line 2284: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2280: END IF;
2281: -- ROLLBACK TO get_inst_party_acct_pub;
2282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2283: IF FND_MSG_PUB.Check_Msg_Level
2284: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2285: THEN
2286: FND_MSG_PUB.Add_Exc_Msg
2287: ( g_pkg_name, l_api_name );
2288: END IF;

Line 2286: FND_MSG_PUB.Add_Exc_Msg

2282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2283: IF FND_MSG_PUB.Check_Msg_Level
2284: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2285: THEN
2286: FND_MSG_PUB.Add_Exc_Msg
2287: ( g_pkg_name, l_api_name );
2288: END IF;
2289: FND_MSG_PUB.Count_And_Get
2290: ( p_count => x_msg_count,

Line 2289: FND_MSG_PUB.Count_And_Get

2285: THEN
2286: FND_MSG_PUB.Add_Exc_Msg
2287: ( g_pkg_name, l_api_name );
2288: END IF;
2289: FND_MSG_PUB.Count_And_Get
2290: ( p_count => x_msg_count,
2291: p_data => x_msg_data );
2292: END get_inst_party_accountS ;
2293:

Line 2347: FND_MSG_PUB.initialize;

2343: END IF;
2344:
2345: -- Initialize message list if p_init_msg_list is set to TRUE.
2346: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2347: FND_MSG_PUB.initialize;
2348: END IF;
2349:
2350: -- Initialize API return status to success
2351: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2407: x_msg_data := FND_MSG_PUB.GET(

2403: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2404: l_msg_index := 1;
2405: l_msg_count := x_msg_count;
2406: WHILE l_msg_count > 0 LOOP
2407: x_msg_data := FND_MSG_PUB.GET(
2408: l_msg_index,
2409: FND_API.G_FALSE );
2410: csi_gen_utility_pvt.put_line( 'message data = '||x_msg_data);
2411: l_msg_index := l_msg_index + 1;

Line 2436: FND_MSG_PUB.Count_And_Get

2432: -- End disable trace
2433: ****/
2434:
2435: -- Standard call to get message count and if count is get message info.
2436: FND_MSG_PUB.Count_And_Get
2437: (p_count => x_msg_count ,
2438: p_data => x_msg_data );
2439: EXCEPTION
2440: WHEN FND_API.G_EXC_ERROR THEN

Line 2443: FND_MSG_PUB.Count_And_Get

2439: EXCEPTION
2440: WHEN FND_API.G_EXC_ERROR THEN
2441: ROLLBACK TO create_inst_party_acct_pub;
2442: x_return_status := FND_API.G_RET_STS_ERROR ;
2443: FND_MSG_PUB.Count_And_Get
2444: ( p_count => x_msg_count,
2445: p_data => x_msg_data );
2446: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2447: ROLLBACK TO create_inst_party_acct_pub;

Line 2449: FND_MSG_PUB.Count_And_Get

2445: p_data => x_msg_data );
2446: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2447: ROLLBACK TO create_inst_party_acct_pub;
2448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2449: FND_MSG_PUB.Count_And_Get
2450: ( p_count => x_msg_count,
2451: p_data => x_msg_data );
2452: WHEN OTHERS THEN
2453: ROLLBACK TO create_inst_party_acct_pub;

Line 2455: IF FND_MSG_PUB.Check_Msg_Level

2451: p_data => x_msg_data );
2452: WHEN OTHERS THEN
2453: ROLLBACK TO create_inst_party_acct_pub;
2454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2455: IF FND_MSG_PUB.Check_Msg_Level
2456: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2457: THEN
2458: FND_MSG_PUB.Add_Exc_Msg
2459: ( g_pkg_name, l_api_name );

Line 2456: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2452: WHEN OTHERS THEN
2453: ROLLBACK TO create_inst_party_acct_pub;
2454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2455: IF FND_MSG_PUB.Check_Msg_Level
2456: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2457: THEN
2458: FND_MSG_PUB.Add_Exc_Msg
2459: ( g_pkg_name, l_api_name );
2460: END IF;

Line 2458: FND_MSG_PUB.Add_Exc_Msg

2454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2455: IF FND_MSG_PUB.Check_Msg_Level
2456: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2457: THEN
2458: FND_MSG_PUB.Add_Exc_Msg
2459: ( g_pkg_name, l_api_name );
2460: END IF;
2461: FND_MSG_PUB.Count_And_Get
2462: ( p_count => x_msg_count,

Line 2461: FND_MSG_PUB.Count_And_Get

2457: THEN
2458: FND_MSG_PUB.Add_Exc_Msg
2459: ( g_pkg_name, l_api_name );
2460: END IF;
2461: FND_MSG_PUB.Count_And_Get
2462: ( p_count => x_msg_count,
2463: p_data => x_msg_data );
2464: END create_inst_party_account;
2465:

Line 2534: FND_MSG_PUB.initialize;

2530: END IF;
2531:
2532: -- Initialize message list if p_init_msg_list is set to TRUE.
2533: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2534: FND_MSG_PUB.initialize;
2535: END IF;
2536:
2537: -- Initialize API return status to success
2538: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2609: x_msg_data := FND_MSG_PUB.GET(

2605: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2606: l_msg_index := 1;
2607: l_msg_count := x_msg_count;
2608: WHILE l_msg_count > 0 LOOP
2609: x_msg_data := FND_MSG_PUB.GET(
2610: l_msg_index,
2611: FND_API.G_FALSE );
2612: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
2613: l_msg_index := l_msg_index + 1;

Line 2687: FND_MSG_PUB.Add;

2683: );
2684: --
2685: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2686: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_CHILDREN_ERROR');
2687: FND_MSG_PUB.Add;
2688: RAISE FND_API.G_EXC_ERROR;
2689: END IF;
2690: --
2691: IF l_rel_tbl.count > 0 THEN

Line 2740: x_msg_data := FND_MSG_PUB.GET(

2736: l_msg_index := 1;
2737: l_msg_count := x_msg_count;
2738: WHILE l_msg_count > 0
2739: LOOP
2740: x_msg_data := FND_MSG_PUB.GET(
2741: l_msg_index,
2742: FND_API.G_FALSE );
2743: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
2744: l_msg_index := l_msg_index + 1;

Line 2776: FND_MSG_PUB.Count_And_Get

2772: -- End disable trace
2773: ****/
2774:
2775: -- Standard call to get message count and if count is get message info.
2776: FND_MSG_PUB.Count_And_Get
2777: (p_count => x_msg_count ,
2778: p_data => x_msg_data );
2779: EXCEPTION
2780: WHEN FND_API.G_EXC_ERROR THEN

Line 2783: FND_MSG_PUB.Count_And_Get

2779: EXCEPTION
2780: WHEN FND_API.G_EXC_ERROR THEN
2781: ROLLBACK TO update_inst_party_acct_pub;
2782: x_return_status := FND_API.G_RET_STS_ERROR ;
2783: FND_MSG_PUB.Count_And_Get
2784: ( p_count => x_msg_count,
2785: p_data => x_msg_data );
2786: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2787: ROLLBACK TO update_inst_party_acct_pub;

Line 2789: FND_MSG_PUB.Count_And_Get

2785: p_data => x_msg_data );
2786: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2787: ROLLBACK TO update_inst_party_acct_pub;
2788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2789: FND_MSG_PUB.Count_And_Get
2790: ( p_count => x_msg_count,
2791: p_data => x_msg_data );
2792: WHEN OTHERS THEN
2793: ROLLBACK TO update_inst_party_acct_pub;

Line 2795: IF FND_MSG_PUB.Check_Msg_Level

2791: p_data => x_msg_data );
2792: WHEN OTHERS THEN
2793: ROLLBACK TO update_inst_party_acct_pub;
2794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2795: IF FND_MSG_PUB.Check_Msg_Level
2796: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2797: THEN
2798: FND_MSG_PUB.Add_Exc_Msg
2799: ( g_pkg_name, l_api_name );

Line 2796: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2792: WHEN OTHERS THEN
2793: ROLLBACK TO update_inst_party_acct_pub;
2794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2795: IF FND_MSG_PUB.Check_Msg_Level
2796: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2797: THEN
2798: FND_MSG_PUB.Add_Exc_Msg
2799: ( g_pkg_name, l_api_name );
2800: END IF;

Line 2798: FND_MSG_PUB.Add_Exc_Msg

2794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2795: IF FND_MSG_PUB.Check_Msg_Level
2796: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2797: THEN
2798: FND_MSG_PUB.Add_Exc_Msg
2799: ( g_pkg_name, l_api_name );
2800: END IF;
2801:
2802: FND_MSG_PUB.Count_And_Get

Line 2802: FND_MSG_PUB.Count_And_Get

2798: FND_MSG_PUB.Add_Exc_Msg
2799: ( g_pkg_name, l_api_name );
2800: END IF;
2801:
2802: FND_MSG_PUB.Count_And_Get
2803: ( p_count => x_msg_count,
2804: p_data => x_msg_data );
2805: END update_inst_party_account ;
2806:

Line 2855: FND_MSG_PUB.initialize;

2851: END IF;
2852:
2853: -- Initialize message list if p_init_msg_list is set to TRUE.
2854: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2855: FND_MSG_PUB.initialize;
2856: END IF;
2857:
2858: -- Initialize API return status to success
2859: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2908: x_msg_data := FND_MSG_PUB.GET(

2904: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2905: l_msg_index := 1;
2906: l_msg_count := x_msg_count;
2907: WHILE l_msg_count > 0 LOOP
2908: x_msg_data := FND_MSG_PUB.GET(
2909: l_msg_index,
2910: FND_API.G_FALSE);
2911: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
2912: l_msg_index := l_msg_index + 1;

Line 2937: FND_MSG_PUB.Count_And_Get

2933: -- End disable trace
2934: ****/
2935:
2936: -- Standard call to get message count and if count is get message info.
2937: FND_MSG_PUB.Count_And_Get
2938: (p_count => x_msg_count ,
2939: p_data => x_msg_data );
2940: EXCEPTION
2941: WHEN FND_API.G_EXC_ERROR THEN

Line 2944: FND_MSG_PUB.Count_And_Get

2940: EXCEPTION
2941: WHEN FND_API.G_EXC_ERROR THEN
2942: ROLLBACK TO expire_inst_party_acct_pub;
2943: x_return_status := FND_API.G_RET_STS_ERROR ;
2944: FND_MSG_PUB.Count_And_Get
2945: ( p_count => x_msg_count,
2946: p_data => x_msg_data );
2947:
2948: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2951: FND_MSG_PUB.Count_And_Get

2947:
2948: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2949: ROLLBACK TO expire_inst_party_acct_pub;
2950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2951: FND_MSG_PUB.Count_And_Get
2952: ( p_count => x_msg_count,
2953: p_data => x_msg_data );
2954: WHEN OTHERS THEN
2955: ROLLBACK TO expire_inst_party_acct_pub;

Line 2958: IF FND_MSG_PUB.Check_Msg_Level

2954: WHEN OTHERS THEN
2955: ROLLBACK TO expire_inst_party_acct_pub;
2956: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2957:
2958: IF FND_MSG_PUB.Check_Msg_Level
2959: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2960: THEN
2961: FND_MSG_PUB.Add_Exc_Msg
2962: ( g_pkg_name, l_api_name );

Line 2959: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2955: ROLLBACK TO expire_inst_party_acct_pub;
2956: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2957:
2958: IF FND_MSG_PUB.Check_Msg_Level
2959: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2960: THEN
2961: FND_MSG_PUB.Add_Exc_Msg
2962: ( g_pkg_name, l_api_name );
2963: END IF;

Line 2961: FND_MSG_PUB.Add_Exc_Msg

2957:
2958: IF FND_MSG_PUB.Check_Msg_Level
2959: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2960: THEN
2961: FND_MSG_PUB.Add_Exc_Msg
2962: ( g_pkg_name, l_api_name );
2963: END IF;
2964: FND_MSG_PUB.Count_And_Get
2965: ( p_count => x_msg_count,

Line 2964: FND_MSG_PUB.Count_And_Get

2960: THEN
2961: FND_MSG_PUB.Add_Exc_Msg
2962: ( g_pkg_name, l_api_name );
2963: END IF;
2964: FND_MSG_PUB.Count_And_Get
2965: ( p_count => x_msg_count,
2966: p_data => x_msg_data );
2967: END expire_inst_party_account ;
2968: END csi_party_relationships_pub ;