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

Line 83: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN

79: ELSE
80: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
81: IBE_UTIL.DEBUG('Not saving party and cust_account_id because account_ids do not match');
82: END IF;
83: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
84: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_USERACCESS');
85: FND_Msg_Pub.Add;
86: END IF;
87: RAISE FND_API.G_EXC_ERROR;

Line 85: FND_Msg_Pub.Add;

81: IBE_UTIL.DEBUG('Not saving party and cust_account_id because account_ids do not match');
82: END IF;
83: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
84: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_USERACCESS');
85: FND_Msg_Pub.Add;
86: END IF;
87: RAISE FND_API.G_EXC_ERROR;
88: END IF;
89: END IF;

Line 137: FND_MSG_PUB.initialize;

133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
134: END IF;
135: -- Initialize message list IF p_init_msg_list is set to TRUE.
136: IF FND_API.to_Boolean( p_init_msg_list ) THEN
137: FND_MSG_PUB.initialize;
138: END IF;
139:
140: -- Initialize API return status to success
141: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 422: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

418: EXCEPTION
419: WHEN FND_API.G_EXC_ERROR THEN
420: ROLLBACK TO SAVESHARE_V2;
421: x_return_status := FND_API.G_RET_STS_ERROR;
422: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
423: p_count => x_msg_count ,
424: p_data => x_msg_data);
425: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
426: IBE_Util.Debug('Expected Error in IBE_QUOTE_SAVESHARE_V2_PVT.save_share_v2()');

Line 432: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

428:
429: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
430: ROLLBACK TO SAVESHARE_V2;
431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
432: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
433: p_count => x_msg_count ,
434: p_data => x_msg_data);
435: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
436: IBE_Util.Debug('Unexpected Error in IBE_QUOTE_SAVESHARE_V2_PVT.save_share_v2()');

Line 442: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN

438:
439: WHEN OTHERS THEN
440: ROLLBACK TO SAVESHARE_V2;
441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
442: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
443: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
444: l_api_name);
445: END IF;
446: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 443: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

439: WHEN OTHERS THEN
440: ROLLBACK TO SAVESHARE_V2;
441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
442: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
443: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
444: l_api_name);
445: END IF;
446: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
447: p_count => x_msg_count ,

Line 446: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

442: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
443: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
444: l_api_name);
445: END IF;
446: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
447: p_count => x_msg_count ,
448: p_data => x_msg_data);
449: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
450: IBE_Util.Debug('Unknown error IBE_QUOTE_SAVESHARE_V2_PVT.save_share_v2()');

Line 563: FND_MSG_PUB.initialize;

559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
560: END IF;
561: -- Initialize message list IF p_init_msg_list is set to TRUE.
562: IF FND_API.to_Boolean( p_init_msg_list ) THEN
563: FND_MSG_PUB.initialize;
564: END IF;
565:
566: -- Initialize API return status to success
567: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1023: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

1019: COMMIT WORK;
1020: END IF;
1021:
1022: -- Standard call to get message count and if count is 1, get message info.
1023: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1024: p_count => x_msg_count ,
1025: p_data => x_msg_data);
1026: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1027: IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_V2_PVT.save_recipients: END');

Line 1034: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

1030: EXCEPTION
1031: WHEN FND_API.G_EXC_ERROR THEN
1032: ROLLBACK TO SAVERECIPIENTS_V2;
1033: x_return_status := FND_API.G_RET_STS_ERROR;
1034: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1035: p_count => x_msg_count ,
1036: p_data => x_msg_data);
1037: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1038: IBE_Util.Debug('Expected error in IBE_QUOTE_SAVESHARE_V2_PVT.SAVE_RECIPIENTS()');

Line 1044: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

1040:
1041: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1042: ROLLBACK TO SAVERECIPIENTS_V2;
1043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1044: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1045: p_count => x_msg_count ,
1046: p_data => x_msg_data);
1047: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1048: IBE_Util.Debug('Unxpected error in IBE_QUOTE_SAVESHARE_V2_PVT.SAVE_RECIPIENTS()');

Line 1054: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN

1050:
1051: WHEN OTHERS THEN
1052: ROLLBACK TO SAVERECIPIENTS_V2;
1053: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1054: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1055: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
1056: l_api_name);
1057: END IF;
1058: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 1055: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

1051: WHEN OTHERS THEN
1052: ROLLBACK TO SAVERECIPIENTS_V2;
1053: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1054: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1055: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
1056: l_api_name);
1057: END IF;
1058: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1059: p_count => x_msg_count ,

Line 1058: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

1054: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1055: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
1056: l_api_name);
1057: END IF;
1058: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1059: p_count => x_msg_count ,
1060: p_data => x_msg_data);
1061: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1062: IBE_Util.Debug('Unknown exception IBE_QUOTE_SAVESHARE_V2_PVT.SAVE_RECIPIENTS()');

Line 1144: FND_MSG_PUB.initialize;

1140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1141: END IF;
1142: -- Initialize message list IF p_init_msg_list is set to TRUE.
1143: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1144: FND_MSG_PUB.initialize;
1145: END IF;
1146:
1147: -- Initialize API return status to success
1148: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1377: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

1373: EXCEPTION
1374: WHEN FND_API.G_EXC_ERROR THEN
1375: ROLLBACK TO ACTIVATEQUOTE_V2;
1376: x_return_status := FND_API.G_RET_STS_ERROR;
1377: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1378: p_count => x_msg_count ,
1379: p_data => x_msg_data);
1380: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1381: IBE_Util.Debug('Expected error in IBE_QUOTE_SAVESHARE_V2_PVT.activate_quote()');

Line 1387: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

1383:
1384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1385: ROLLBACK TO ACTIVATEQUOTE_V2;
1386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1387: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1388: p_count => x_msg_count ,
1389: p_data => x_msg_data);
1390: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1391: IBE_Util.Debug('Unexpected error in IBE_QUOTE_SAVESHARE_V2_PVT.activate_quote()');

Line 1397: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN

1393:
1394: WHEN OTHERS THEN
1395: ROLLBACK TO ACTIVATEQUOTE_V2;
1396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1397: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1398: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
1399: l_api_name);
1400: END IF;
1401: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 1398: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

1394: WHEN OTHERS THEN
1395: ROLLBACK TO ACTIVATEQUOTE_V2;
1396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1397: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1398: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
1399: l_api_name);
1400: END IF;
1401: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1402: p_count => x_msg_count ,

Line 1401: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

1397: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1398: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
1399: l_api_name);
1400: END IF;
1401: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1402: p_count => x_msg_count ,
1403: p_data => x_msg_data);
1404: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1405: IBE_Util.Debug('Unknown error IBE_QUOTE_SAVESHARE_V2_PVT.activate_quote()');

Line 1463: FND_MSG_PUB.initialize;

1459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1460: END IF;
1461: -- Initialize message list IF p_init_msg_list is set to TRUE.
1462: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1463: FND_MSG_PUB.initialize;
1464: END IF;
1465:
1466: -- Initialize API return status to success
1467: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1574: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1570: COMMIT WORK;
1571: END IF;
1572:
1573: -- Standard call to get message count and IF count is 1, get message info.
1574: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1575: p_count => x_msg_count,
1576: p_data => x_msg_data);
1577: EXCEPTION
1578: WHEN FND_API.G_EXC_ERROR THEN

Line 1584: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1580: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1581: IBE_UTIL.DEBUG('Expected exception in Ibe_quote_saveshare_v2_pvt.SaveContactPoint');
1582: end if;
1583: x_return_status := FND_API.G_RET_STS_ERROR;
1584: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1585: p_count => x_msg_count,
1586: p_data => x_msg_data);
1587: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1588: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 1594: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1590: end if;
1591:
1592: ROLLBACK TO SAVECONTACTPOINT_PVT;
1593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1594: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1595: p_count => x_msg_count,
1596: p_data => x_msg_data);
1597: WHEN OTHERS THEN
1598: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

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

1601:
1602: ROLLBACK TO SAVECONTACTPOINT_PVT;
1603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1604:
1605: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1606: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
1607: l_api_name);
1608: END IF;
1609:

Line 1606: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

1602: ROLLBACK TO SAVECONTACTPOINT_PVT;
1603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1604:
1605: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1606: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
1607: l_api_name);
1608: END IF;
1609:
1610: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 1610: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1606: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
1607: l_api_name);
1608: END IF;
1609:
1610: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1611: p_count => x_msg_count,
1612: p_data => x_msg_data);
1613: END SAVE_CONTACT_POINT;
1614:

Line 1660: FND_MSG_PUB.initialize;

1656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1657: END IF;
1658: -- Initialize message list IF p_init_msg_list is set to TRUE.
1659: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1660: FND_MSG_PUB.initialize;
1661: END IF;
1662:
1663: -- Initialize API return status to success
1664: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1722: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

1718: IBE_UTIL.DEBUG('Expected exception in Ibe_quote_saveshare_v2_pvt.Deactivate_quote');
1719: end if;
1720:
1721: x_return_status := FND_API.G_RET_STS_ERROR;
1722: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1723: p_count => x_msg_count ,
1724: p_data => x_msg_data);
1725: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1726: IBE_Util.Debug('Unexpected error in IBE_QUOTE_SAVESHARE_V2_PVT.deactivate_quote');

Line 1732: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

1728:
1729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1730: ROLLBACK TO DEACTIVATEQUOTE_V2;
1731: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1732: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1733: p_count => x_msg_count ,
1734: p_data => x_msg_data);
1735: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1736: IBE_Util.Debug('Unknown error in IBE_QUOTE_SAVESHARE_V2_PVT.deactivate_quote');

Line 1742: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN

1738:
1739: WHEN OTHERS THEN
1740: ROLLBACK TO DEACTIVATEQUOTE_V2;
1741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1742: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1743: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
1744: l_api_name);
1745: END IF;
1746: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 1743: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

1739: WHEN OTHERS THEN
1740: ROLLBACK TO DEACTIVATEQUOTE_V2;
1741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1742: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1743: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
1744: l_api_name);
1745: END IF;
1746: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1747: p_count => x_msg_count ,

Line 1746: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

1742: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1743: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
1744: l_api_name);
1745: END IF;
1746: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1747: p_count => x_msg_count ,
1748: p_data => x_msg_data);
1749: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1750: IBE_Util.Debug('Abnormal end IBE_QUOTE_SAVESHARE_V2_PVT.deactivate_quote');

Line 1807: FND_MSG_PUB.initialize;

1803: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1804: END IF;
1805: -- Initialize message list IF p_init_msg_list is set to TRUE.
1806: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1807: FND_MSG_PUB.initialize;
1808: END IF;
1809:
1810: -- Initialize API return status to success
1811: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1940: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

1936: EXCEPTION
1937: WHEN FND_API.G_EXC_ERROR THEN
1938: ROLLBACK TO APPENDQUOTE_V2;
1939: x_return_status := FND_API.G_RET_STS_ERROR;
1940: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1941: p_count => x_msg_count ,
1942: p_data => x_msg_data);
1943: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1944: IBE_Util.Debug('Expected error in IBE_QUOTE_SAVESHARE_V2_PVT.append_quote()');

Line 1950: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

1946:
1947: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1948: ROLLBACK TO APPENDQUOTE_V2;
1949: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1950: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1951: p_count => x_msg_count ,
1952: p_data => x_msg_data);
1953: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1954: IBE_Util.Debug('Unexpected error in IBE_QUOTE_SAVESHARE_V2_PVT.append_quote()');

Line 1960: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN

1956:
1957: WHEN OTHERS THEN
1958: ROLLBACK TO APPENDQUOTE_V2;
1959: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1960: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1961: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
1962: l_api_name);
1963: END IF;
1964: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 1961: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

1957: WHEN OTHERS THEN
1958: ROLLBACK TO APPENDQUOTE_V2;
1959: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1960: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1961: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
1962: l_api_name);
1963: END IF;
1964: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1965: p_count => x_msg_count ,

Line 1964: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

1960: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1961: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
1962: l_api_name);
1963: END IF;
1964: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1965: p_count => x_msg_count ,
1966: p_data => x_msg_data);
1967: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1968: IBE_Util.Debug('Abnormal end IBE_QUOTE_SAVESHARE_V2_PVT.append_quote()');

Line 2059: FND_MSG_PUB.initialize;

2055: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2056: END IF;
2057: -- Initialize message list IF p_init_msg_list is set to TRUE.
2058: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2059: FND_MSG_PUB.initialize;
2060: END IF;
2061:
2062: -- Initialize API return status to success
2063: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2262: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

2258:
2259: WHEN FND_API.G_EXC_ERROR THEN
2260: ROLLBACK TO STOPSHARING_V2;
2261: x_return_status := FND_API.G_RET_STS_ERROR;
2262: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2263: p_count => x_msg_count ,
2264: p_data => x_msg_data);
2265: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2266: IBE_Util.Debug('Expected error in IBE_QUOTE_SAVESHARE_V2_PVT.STOPSHARING_V2');

Line 2272: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

2268:
2269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2270: ROLLBACK TO STOPSHARING_V2;
2271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2272: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2273: p_count => x_msg_count ,
2274: p_data => x_msg_data);
2275: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2276: IBE_Util.Debug('Unexpected error in IBE_QUOTE_SAVESHARE_V2_PVT.STOPSHARING_V2');

Line 2282: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN

2278:
2279: WHEN OTHERS THEN
2280: ROLLBACK TO STOPSHARING_V2;
2281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2282: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2283: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
2284: l_api_name);
2285: END IF;
2286: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 2283: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

2279: WHEN OTHERS THEN
2280: ROLLBACK TO STOPSHARING_V2;
2281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2282: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2283: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
2284: l_api_name);
2285: END IF;
2286: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2287: p_count => x_msg_count ,

Line 2286: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

2282: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2283: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
2284: l_api_name);
2285: END IF;
2286: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2287: p_count => x_msg_count ,
2288: p_data => x_msg_data);
2289: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2290: IBE_Util.Debug('Unknown error in IBE_QUOTE_SAVESHARE_V2_PVT.STOPSHARING_V2');

Line 2364: FND_MSG_PUB.initialize;

2360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2361: END IF;
2362: -- Initialize message list IF p_init_msg_list is set to TRUE.
2363: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2364: FND_MSG_PUB.initialize;
2365: END IF;
2366:
2367: -- Initialize API return status to success
2368: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2479: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

2475: EXCEPTION
2476: WHEN FND_API.G_EXC_ERROR THEN
2477: ROLLBACK TO ENDWORKING_V2;
2478: x_return_status := FND_API.G_RET_STS_ERROR;
2479: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2480: p_count => x_msg_count ,
2481: p_data => x_msg_data);
2482: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2483: IBE_Util.Debug('Expected error in IBE_QUOTE_SAVESHARE_V2_PVT.ENDWORKING');

Line 2489: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

2485:
2486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2487: ROLLBACK TO ENDWORKING_V2;
2488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2489: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2490: p_count => x_msg_count ,
2491: p_data => x_msg_data);
2492: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2493: IBE_Util.Debug('Unexpected error in IBE_QUOTE_SAVESHARE_V2_PVT.ENDWORKING)');

Line 2499: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN

2495:
2496: WHEN OTHERS THEN
2497: ROLLBACK TO ENDWORKING_V2;
2498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2499: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2500: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
2501: l_api_name);
2502: END IF;
2503: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 2500: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

2496: WHEN OTHERS THEN
2497: ROLLBACK TO ENDWORKING_V2;
2498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2499: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2500: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
2501: l_api_name);
2502: END IF;
2503: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2504: p_count => x_msg_count ,

Line 2503: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

2499: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2500: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
2501: l_api_name);
2502: END IF;
2503: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2504: p_count => x_msg_count ,
2505: p_data => x_msg_data);
2506: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2507: IBE_Util.Debug('Unknown error in IBE_QUOTE_SAVESHARE_V2_PVT.ENDWORKING');

Line 2559: FND_MSG_PUB.initialize;

2555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2556: END IF;
2557: -- Initialize message list IF p_init_msg_list is set to TRUE.
2558: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2559: FND_MSG_PUB.initialize;
2560: END IF;
2561:
2562: -- Initialize API return status to success
2563: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2631: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

2627:
2628: WHEN FND_API.G_EXC_ERROR THEN
2629: ROLLBACK TO STOPSHARING_V2;
2630: x_return_status := FND_API.G_RET_STS_ERROR;
2631: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2632: p_count => x_msg_count ,
2633: p_data => x_msg_data);
2634: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2635: IBE_Util.Debug('Expected error in IBE_QUOTE_SAVESHARE_V2_PVT.SHAREREADONLY_V2');

Line 2641: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

2637:
2638: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2639: ROLLBACK TO STOPSHARING_V2;
2640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2641: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2642: p_count => x_msg_count ,
2643: p_data => x_msg_data);
2644: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2645: IBE_Util.Debug('Unexpected error in IBE_QUOTE_SAVESHARE_V2_PVT.SHAREREADONLY_V2');

Line 2651: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN

2647:
2648: WHEN OTHERS THEN
2649: ROLLBACK TO STOPSHARING_V2;
2650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2651: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2652: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
2653: l_api_name);
2654: END IF;
2655: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 2652: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

2648: WHEN OTHERS THEN
2649: ROLLBACK TO STOPSHARING_V2;
2650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2651: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2652: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
2653: l_api_name);
2654: END IF;
2655: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2656: p_count => x_msg_count ,

Line 2655: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

2651: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2652: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
2653: l_api_name);
2654: END IF;
2655: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2656: p_count => x_msg_count ,
2657: p_data => x_msg_data);
2658: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2659: IBE_Util.Debug('Unknown error in IBE_QUOTE_SAVESHARE_V2_PVT.SHAREREADONLY_V2');

Line 2735: FND_MSG_PUB.initialize;

2731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2732: END IF;
2733: -- Initialize message list IF p_init_msg_list is set to TRUE.
2734: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2735: FND_MSG_PUB.initialize;
2736: END IF;
2737:
2738: -- Initialize API return status to success
2739: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2885: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

2881: EXCEPTION
2882: WHEN FND_API.G_EXC_ERROR THEN
2883: ROLLBACK TO DELETERECIPIENT_V2;
2884: x_return_status := FND_API.G_RET_STS_ERROR;
2885: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2886: p_count => x_msg_count ,
2887: p_data => x_msg_data);
2888: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2889: IBE_Util.Debug('Expected error in IBE_QUOTE_SAVESHARE_V2_PVT.DELETE_RECIPIENT()');

Line 2895: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

2891:
2892: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2893: ROLLBACK TO DELETERECIPIENT_V2;
2894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2895: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2896: p_count => x_msg_count ,
2897: p_data => x_msg_data);
2898: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2899: IBE_Util.Debug('Unexpected error in IBE_QUOTE_SAVESHARE_V2_PVT.DELETE_RECIPIENT()');

Line 2905: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN

2901:
2902: WHEN OTHERS THEN
2903: ROLLBACK TO DELETERECIPIENT_V2;
2904: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2905: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2906: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
2907: l_api_name);
2908: END IF;
2909: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 2906: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

2902: WHEN OTHERS THEN
2903: ROLLBACK TO DELETERECIPIENT_V2;
2904: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2905: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2906: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
2907: l_api_name);
2908: END IF;
2909: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2910: p_count => x_msg_count ,

Line 2909: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

2905: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2906: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
2907: l_api_name);
2908: END IF;
2909: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2910: p_count => x_msg_count ,
2911: p_data => x_msg_data);
2912: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2913: IBE_Util.Debug('Unknown error in IBE_QUOTE_SAVESHARE_V2_PVT.DELETE_RECIPIENT()');

Line 3002: FND_Msg_Pub.initialize;

2998:
2999: -- Initialize message list if p_init_msg_list is set to TRUE.
3000:
3001: IF FND_API.To_Boolean( p_init_msg_list ) THEN
3002: FND_Msg_Pub.initialize;
3003: END IF;
3004:
3005: -- Initialize API return status to success
3006: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3058: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN

3054: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3055: IBE_Util.Debug('RECIPIENT access level: ' || l_access_level);
3056: END IF;
3057: if (l_access_level is null) then
3058: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
3059: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_USERACCESS');
3060: FND_Msg_Pub.Add;
3061: END IF;
3062: -- need to raise an error that the user no longer has access to this cart

Line 3060: FND_Msg_Pub.Add;

3056: END IF;
3057: if (l_access_level is null) then
3058: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
3059: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_USERACCESS');
3060: FND_Msg_Pub.Add;
3061: END IF;
3062: -- need to raise an error that the user no longer has access to this cart
3063: RAISE FND_API.G_EXC_ERROR;
3064: end if;

Line 3071: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN

3067: ------------ DETERMINE WHICH VALIDATIONS TO DO BASED ON OP CODE ------------------------------
3068: -- owner only operations
3069: if (p_operation_code in (OP_APPEND, OP_NAME_CART, OP_SAVE_CART_AND_RECIPIENTS)) then
3070: if (l_is_owner = FND_API.G_FALSE) then
3071: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
3072: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_PRIVILEGE');
3073: FND_Msg_Pub.Add;
3074: END IF;
3075: -- raise an error that the user does not have this privilege

Line 3073: FND_Msg_Pub.Add;

3069: if (p_operation_code in (OP_APPEND, OP_NAME_CART, OP_SAVE_CART_AND_RECIPIENTS)) then
3070: if (l_is_owner = FND_API.G_FALSE) then
3071: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
3072: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_PRIVILEGE');
3073: FND_Msg_Pub.Add;
3074: END IF;
3075: -- raise an error that the user does not have this privilege
3076: RAISE FND_API.G_EXC_ERROR;
3077: end if;

Line 3084: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN

3080: end if;
3081: -- owner or admin operations
3082: elsif (p_operation_code in (OP_STOP_SHARING, OP_DELETE_CART)) then
3083: if ((l_is_owner = FND_API.G_FALSE) and (l_access_level <> 'A')) then
3084: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
3085: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_PRIVILEGE');
3086: FND_Msg_Pub.Add;
3087: END IF;
3088: -- raise an error that the user does not have this privilege

Line 3086: FND_Msg_Pub.Add;

3082: elsif (p_operation_code in (OP_STOP_SHARING, OP_DELETE_CART)) then
3083: if ((l_is_owner = FND_API.G_FALSE) and (l_access_level <> 'A')) then
3084: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
3085: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_PRIVILEGE');
3086: FND_Msg_Pub.Add;
3087: END IF;
3088: -- raise an error that the user does not have this privilege
3089: RAISE FND_API.G_EXC_ERROR;
3090: end if;

Line 3146: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN

3142: or ((p_quote_access_tbl(i).operation_code = 'UPDATE')
3143: and (p_quote_access_tbl(i).update_privilege_type_code is not null)
3144: and (p_quote_access_tbl(i).update_privilege_type_code <> FND_API.G_MISS_CHAR)
3145: and (p_quote_access_tbl(i).update_privilege_type_code <> l_db_quote_access_tbl(i).update_privilege_type_code))) then
3146: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
3147: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_PRIVILEGE');
3148: FND_Msg_Pub.Add;
3149: END IF;
3150: RAISE FND_API.G_EXC_ERROR;

Line 3148: FND_Msg_Pub.Add;

3144: and (p_quote_access_tbl(i).update_privilege_type_code <> FND_API.G_MISS_CHAR)
3145: and (p_quote_access_tbl(i).update_privilege_type_code <> l_db_quote_access_tbl(i).update_privilege_type_code))) then
3146: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
3147: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_PRIVILEGE');
3148: FND_Msg_Pub.Add;
3149: END IF;
3150: RAISE FND_API.G_EXC_ERROR;
3151: end if;
3152: end if; -- end check onlynotify

Line 3176: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN

3172: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3173: IBE_UTIL.DEBUG('timestamps do not match, but user was the last to update the row so allowing it to go through');
3174: end if;
3175: else
3176: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
3177: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_MEMBERS_OUT_OF_SYNC');
3178: FND_Msg_Pub.Add;
3179: END IF;
3180: -- need a new error msg that the row has been updated by another user and to try again

Line 3178: FND_Msg_Pub.Add;

3174: end if;
3175: else
3176: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
3177: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_MEMBERS_OUT_OF_SYNC');
3178: FND_Msg_Pub.Add;
3179: END IF;
3180: -- need a new error msg that the row has been updated by another user and to try again
3181: RAISE FND_API.G_EXC_ERROR;
3182: end if;

Line 3196: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

3192:
3193: EXCEPTION
3194: WHEN FND_API.G_EXC_ERROR THEN
3195: x_return_status := FND_API.G_RET_STS_ERROR;
3196: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
3197: p_count => x_msg_count ,
3198: p_data => x_msg_data);
3199: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3200: IBE_Util.Debug('End IBE_Quote_Misc_pvt.validate_share_update: expected error');

Line 3204: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

3200: IBE_Util.Debug('End IBE_Quote_Misc_pvt.validate_share_update: expected error');
3201: END IF;
3202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3204: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
3205: p_count => x_msg_count ,
3206: p_data => x_msg_data);
3207: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3208: IBE_Util.Debug('End IBE_Quote_Misc_pvt.validate_share_update: unexpected error');

Line 3211: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN

3207: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3208: IBE_Util.Debug('End IBE_Quote_Misc_pvt.validate_share_update: unexpected error');
3209: END IF;
3210: WHEN OTHERS THEN
3211: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
3212: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
3213: l_api_name);
3214: END IF;
3215: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 3212: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

3208: IBE_Util.Debug('End IBE_Quote_Misc_pvt.validate_share_update: unexpected error');
3209: END IF;
3210: WHEN OTHERS THEN
3211: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
3212: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
3213: l_api_name);
3214: END IF;
3215: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
3216: p_count => x_msg_count ,

Line 3215: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

3211: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
3212: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
3213: l_api_name);
3214: END IF;
3215: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
3216: p_count => x_msg_count ,
3217: p_data => x_msg_data);
3218: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3219: IBE_Util.Debug('End IBE_Quote_Misc_pvt.validate_share_update: other exception');