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.AMS_PARTY_MKT_SEG_LOADER_PVT dependencies on FND_MSG_PUB

Line 9: G_DEBUG_LEVEL BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);

5: G_FILE_NAME CONSTANT VARCHAR2(12):='amsvldrb.pls';
6:
7:
8: /* variable to on-off the debug messages of the programe */
9: G_DEBUG_LEVEL BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
10:
11:
12: -- yzhao: type definition for load_party_market... used internally
13: TYPE NUMBER_TBL_TYPE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 47: -- l_count := FND_MSG_PUB.count_msg;

43: -- l_msg VARCHAR2(2000);
44: -- l_cnt NUMBER ;
45: --BEGIN
46: -- IF p_text IS NULL THEN
47: -- l_count := FND_MSG_PUB.count_msg;
48: -- FOR l_cnt IN 1 .. l_count LOOP
49: -- l_msg := FND_MSG_PUB.get(l_cnt, FND_API.g_false);
50: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '(' || l_cnt || ') ' || l_msg);
51: -- END LOOP;

Line 49: -- l_msg := FND_MSG_PUB.get(l_cnt, FND_API.g_false);

45: --BEGIN
46: -- IF p_text IS NULL THEN
47: -- l_count := FND_MSG_PUB.count_msg;
48: -- FOR l_cnt IN 1 .. l_count LOOP
49: -- l_msg := FND_MSG_PUB.get(l_cnt, FND_API.g_false);
50: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '(' || l_cnt || ') ' || l_msg);
51: -- END LOOP;
52: -- ELSE
53: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT, p_text );

Line 151: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

147: END IF;
148:
149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
150:
151: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
152: THEN
153: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
154: END IF;
155:

Line 153: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
150:
151: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
152: THEN
153: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
154: END IF;
155:
156: FND_MSG_PUB.Count_AND_Get
157: ( p_count => x_msg_count,

Line 156: FND_MSG_PUB.Count_AND_Get

152: THEN
153: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
154: END IF;
155:
156: FND_MSG_PUB.Count_AND_Get
157: ( p_count => x_msg_count,
158: p_data => x_msg_data,
159: p_encoded => FND_API.G_FALSE
160: );

Line 259: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

255: END IF;
256:
257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
258:
259: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
260: THEN
261: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
262: END IF;
263:

Line 261: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
258:
259: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
260: THEN
261: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
262: END IF;
263:
264: FND_MSG_PUB.Count_AND_Get
265: ( p_count => x_msg_count,

Line 264: FND_MSG_PUB.Count_AND_Get

260: THEN
261: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
262: END IF;
263:
264: FND_MSG_PUB.Count_AND_Get
265: ( p_count => x_msg_count,
266: p_data => x_msg_data,
267: p_encoded => FND_API.G_FALSE
268: );

Line 448: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

444: END IF;
445:
446: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
447:
448: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
449: THEN
450: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
451: END IF;
452:

Line 450: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

446: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
447:
448: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
449: THEN
450: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
451: END IF;
452:
453: FND_MSG_PUB.Count_AND_Get
454: ( p_count => x_msg_count,

Line 453: FND_MSG_PUB.Count_AND_Get

449: THEN
450: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
451: END IF;
452:
453: FND_MSG_PUB.Count_AND_Get
454: ( p_count => x_msg_count,
455: p_data => x_msg_data,
456: p_encoded => FND_API.G_FALSE
457: );

Line 543: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

539: CLOSE c_old_party_id;
540: END IF;
541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
542:
543: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
544: THEN
545: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
546: END IF;
547:

Line 545: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
542:
543: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
544: THEN
545: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
546: END IF;
547:
548: FND_MSG_PUB.Count_AND_Get
549: ( p_count => x_msg_count,

Line 548: FND_MSG_PUB.Count_AND_Get

544: THEN
545: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
546: END IF;
547:
548: FND_MSG_PUB.Count_AND_Get
549: ( p_count => x_msg_count,
550: p_data => x_msg_data,
551: p_encoded => FND_API.G_FALSE
552: );

Line 639: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

635: END IF;
636:
637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
638:
639: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
640: THEN
641: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
642: END IF;
643:

Line 641: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
638:
639: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
640: THEN
641: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
642: END IF;
643:
644: FND_MSG_PUB.Count_AND_Get
645: ( p_count => x_msg_count,

Line 644: FND_MSG_PUB.Count_AND_Get

640: THEN
641: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
642: END IF;
643:
644: FND_MSG_PUB.Count_AND_Get
645: ( p_count => x_msg_count,
646: p_data => x_msg_data,
647: p_encoded => FND_API.G_FALSE
648: );

Line 823: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

819: END IF;
820:
821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
822:
823: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
824: THEN
825: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
826: END IF;
827:

Line 825: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
822:
823: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
824: THEN
825: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
826: END IF;
827:
828: FND_MSG_PUB.Count_AND_Get
829: ( p_count => x_msg_count,

Line 828: FND_MSG_PUB.Count_AND_Get

824: THEN
825: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
826: END IF;
827:
828: FND_MSG_PUB.Count_AND_Get
829: ( p_count => x_msg_count,
830: p_data => x_msg_data,
831: p_encoded => FND_API.G_FALSE
832: );

Line 1053: FND_MSG_PUB.count_and_get(

1049: IF (DBMS_SQL.Is_Open(l_party_cur) = TRUE) THEN
1050: DBMS_SQL.Close_Cursor(l_party_cur) ;
1051: END IF;
1052: x_return_status := FND_API.g_ret_sts_error;
1053: FND_MSG_PUB.count_and_get(
1054: p_encoded => FND_API.g_false,
1055: p_count => x_msg_count,
1056: p_data => x_msg_data
1057: );

Line 1063: FND_MSG_PUB.count_and_get (

1059: IF (DBMS_SQL.Is_Open(l_party_cur) = TRUE) THEN
1060: DBMS_SQL.Close_Cursor(l_party_cur) ;
1061: END IF;
1062: x_return_status := FND_API.g_ret_sts_unexp_error ;
1063: FND_MSG_PUB.count_and_get (
1064: p_encoded => FND_API.g_false,
1065: p_count => x_msg_count,
1066: p_data => x_msg_data
1067: );

Line 1075: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1071: DBMS_SQL.Close_Cursor(l_party_cur) ;
1072: END IF;
1073: x_return_status := FND_API.g_ret_sts_unexp_error ;
1074:
1075: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1076: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1077: END IF;
1078:
1079: FND_MSG_PUB.count_and_get (

Line 1076: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

1072: END IF;
1073: x_return_status := FND_API.g_ret_sts_unexp_error ;
1074:
1075: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1076: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1077: END IF;
1078:
1079: FND_MSG_PUB.count_and_get (
1080: p_encoded => FND_API.g_false,

Line 1079: FND_MSG_PUB.count_and_get (

1075: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1076: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1077: END IF;
1078:
1079: FND_MSG_PUB.count_and_get (
1080: p_encoded => FND_API.g_false,
1081: p_count => x_msg_count,
1082: p_data => x_msg_data
1083: );

Line 1258: FND_MSG_PUB.count_and_get(

1254: IF (DBMS_SQL.Is_Open(l_party_cur) = TRUE) THEN
1255: DBMS_SQL.Close_Cursor(l_party_cur) ;
1256: END IF;
1257: x_return_status := FND_API.g_ret_sts_error;
1258: FND_MSG_PUB.count_and_get(
1259: p_encoded => FND_API.g_false,
1260: p_count => x_msg_count,
1261: p_data => x_msg_data
1262: );

Line 1268: FND_MSG_PUB.count_and_get (

1264: IF (DBMS_SQL.Is_Open(l_party_cur) = TRUE) THEN
1265: DBMS_SQL.Close_Cursor(l_party_cur) ;
1266: END IF;
1267: x_return_status := FND_API.g_ret_sts_unexp_error ;
1268: FND_MSG_PUB.count_and_get (
1269: p_encoded => FND_API.g_false,
1270: p_count => x_msg_count,
1271: p_data => x_msg_data
1272: );

Line 1279: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1275: DBMS_SQL.Close_Cursor(l_party_cur) ;
1276: END IF;
1277: x_return_status := FND_API.g_ret_sts_unexp_error ;
1278:
1279: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1280: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1281: END IF;
1282:
1283: FND_MSG_PUB.count_and_get (

Line 1280: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

1276: END IF;
1277: x_return_status := FND_API.g_ret_sts_unexp_error ;
1278:
1279: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1280: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1281: END IF;
1282:
1283: FND_MSG_PUB.count_and_get (
1284: p_encoded => FND_API.g_false,

Line 1283: FND_MSG_PUB.count_and_get (

1279: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1280: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1281: END IF;
1282:
1283: FND_MSG_PUB.count_and_get (
1284: p_encoded => FND_API.g_false,
1285: p_count => x_msg_count,
1286: p_data => x_msg_data
1287: );

Line 1525: FND_MSG_PUB.count_and_get (

1521: CLOSE c_all_cell_rec;
1522: END IF;
1523: ROLLBACK TO Load_Party_Mkt_Seg;
1524: x_return_status := FND_API.g_ret_sts_error;
1525: FND_MSG_PUB.count_and_get (
1526: p_encoded => FND_API.g_false,
1527: p_count => x_msg_count,
1528: p_data => x_msg_data
1529: );

Line 1542: FND_MSG_PUB.count_and_get (

1538: CLOSE c_all_cell_rec;
1539: END IF;
1540: ROLLBACK TO Load_Party_Mkt_Seg;
1541: x_return_status := FND_API.g_ret_sts_unexp_error ;
1542: FND_MSG_PUB.count_and_get (
1543: p_encoded => FND_API.g_false,
1544: p_count => x_msg_count,
1545: p_data => x_msg_data
1546: );

Line 1560: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1556: END IF;
1557: ROLLBACK TO Load_Party_Mkt_Seg;
1558: x_return_status := FND_API.g_ret_sts_unexp_error ;
1559:
1560: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1561: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1562: END IF;
1563: FND_MSG_PUB.count_and_get (
1564: p_encoded => FND_API.g_false,

Line 1561: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

1557: ROLLBACK TO Load_Party_Mkt_Seg;
1558: x_return_status := FND_API.g_ret_sts_unexp_error ;
1559:
1560: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1561: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1562: END IF;
1563: FND_MSG_PUB.count_and_get (
1564: p_encoded => FND_API.g_false,
1565: p_count => x_msg_count,

Line 1563: FND_MSG_PUB.count_and_get (

1559:
1560: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1561: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1562: END IF;
1563: FND_MSG_PUB.count_and_get (
1564: p_encoded => FND_API.g_false,
1565: p_count => x_msg_count,
1566: p_data => x_msg_data
1567: );

Line 1597: FND_MSG_PUB.initialize;

1593: l_return_status VARCHAR2(1) ;
1594: l_msg_count NUMBER ;
1595: l_msg_data VARCHAR2(2000);
1596: BEGIN
1597: FND_MSG_PUB.initialize;
1598: -- Call the procedure to refresh the Market Segment
1599: -- Call procedure in new package to refresh the segments
1600:
1601: AMS_Party_Seg_Loader_PVT.Load_Party_Seg

Line 1779: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1775: --
1776: OPEN c_ws_name ;
1777: FETCH c_ws_name INTO l_dummy ;
1778: IF c_ws_name%NOTFOUND THEN
1779: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1780: -- Invalid SQL for the Discoverer
1781: FND_MESSAGE.set_name('AMS', 'AMS_MKS_NO_WB');
1782: FND_MESSAGE.Set_Token('WORKBOOK', p_workbook_name);
1783: FND_MESSAGE.Set_Token('CELL', p_cell_name);

Line 1784: FND_MSG_PUB.Add;

1780: -- Invalid SQL for the Discoverer
1781: FND_MESSAGE.set_name('AMS', 'AMS_MKS_NO_WB');
1782: FND_MESSAGE.Set_Token('WORKBOOK', p_workbook_name);
1783: FND_MESSAGE.Set_Token('CELL', p_cell_name);
1784: FND_MSG_PUB.Add;
1785: CLOSE c_ws_name ;
1786: RAISE FND_API.G_EXC_ERROR;
1787: END IF;
1788: END IF ;

Line 1806: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1802:
1803: IF (l_found = FND_API.G_FALSE) THEN
1804: AMS_Utility_PVT.debug_message(l_full_name||': Invalid SQL');
1805: --
1806: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1807: -- Invalid SQL for the Discoverer
1808: FND_MESSAGE.set_name('AMS', 'AMS_MKS_BAD_WB');
1809: FND_MESSAGE.Set_Token('CELL', p_cell_name);
1810: FND_MSG_PUB.Add;

Line 1810: FND_MSG_PUB.Add;

1806: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1807: -- Invalid SQL for the Discoverer
1808: FND_MESSAGE.set_name('AMS', 'AMS_MKS_BAD_WB');
1809: FND_MESSAGE.Set_Token('CELL', p_cell_name);
1810: FND_MSG_PUB.Add;
1811: CLOSE c_ws_name ;
1812: RAISE FND_API.G_EXC_ERROR;
1813: END IF;
1814: ELSIF(l_found = FND_API.G_TRUE)THEN

Line 1845: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1841:
1842: IF (l_found = FND_API.G_FALSE) THEN
1843: AMS_Utility_PVT.debug_message(l_full_name||': No party ID in the SQL');
1844: --
1845: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1846: -- Invalid SQL for the Discoverer
1847: FND_MESSAGE.set_name('AMS', 'AMS_MKS_BAD_WB');
1848: FND_MESSAGE.Set_Token('CELL', p_cell_name);
1849: FND_MSG_PUB.Add;

Line 1849: FND_MSG_PUB.Add;

1845: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1846: -- Invalid SQL for the Discoverer
1847: FND_MESSAGE.set_name('AMS', 'AMS_MKS_BAD_WB');
1848: FND_MESSAGE.Set_Token('CELL', p_cell_name);
1849: FND_MSG_PUB.Add;
1850: CLOSE c_ws_name ;
1851: RAISE FND_API.G_EXC_ERROR;
1852: END IF;
1853: ELSIF(l_found = FND_API.G_TRUE)THEN

Line 1938: FND_MSG_PUB.Count_AND_Get

1934: WHEN FND_API.G_EXC_ERROR THEN
1935:
1936: x_return_status := FND_API.G_RET_STS_ERROR ;
1937:
1938: FND_MSG_PUB.Count_AND_Get
1939: ( p_count => x_msg_count,
1940: p_data => x_msg_data,
1941: p_encoded => FND_API.G_FALSE
1942: );

Line 1949: FND_MSG_PUB.Count_AND_Get

1945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1946:
1947: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1948:
1949: FND_MSG_PUB.Count_AND_Get
1950: ( p_count => x_msg_count,
1951: p_data => x_msg_data,
1952: p_encoded => FND_API.G_FALSE
1953: );

Line 1960: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

1956: WHEN OTHERS THEN
1957:
1958: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1959:
1960: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1961: THEN
1962: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1963: END IF;
1964:

Line 1962: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1958: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1959:
1960: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1961: THEN
1962: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1963: END IF;
1964:
1965: FND_MSG_PUB.Count_AND_Get
1966: ( p_count => x_msg_count,

Line 1965: FND_MSG_PUB.Count_AND_Get

1961: THEN
1962: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1963: END IF;
1964:
1965: FND_MSG_PUB.Count_AND_Get
1966: ( p_count => x_msg_count,
1967: p_data => x_msg_data,
1968: p_encoded => FND_API.G_FALSE
1969: );

Line 1999: FND_MSG_PUB.initialize;

1995: l_return_status VARCHAR2(1) ;
1996: l_msg_count NUMBER ;
1997: l_msg_data VARCHAR2(2000);
1998: BEGIN
1999: FND_MSG_PUB.initialize;
2000: -- Call the procedure to refresh Segment size
2001: AMS_Cell_PVT.Update_Segment_Size
2002: ( p_cell_id => p_cell_id,
2003: x_return_status => l_return_status,

Line 2621: FND_MSG_PUB.initialize;

2617: FROM DUAL;
2618: */
2619: BEGIN
2620: p_retcode := 0;
2621: FND_MSG_PUB.initialize;
2622: Ams_Utility_pvt.Write_Conc_log(l_full_name || ': START for territory ' || p_terr_id);
2623: l_terr_id := p_terr_id;
2624: l_client_info := TO_NUMBER(SUBSTRB(userenv('CLIENT_INFO'), 1, 10));
2625: l_final_bind_vars := p_bind_vars;