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 2241: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

2237:
2238: WHEN FND_API.G_EXC_ERROR THEN
2239: ROLLBACK TO STOPSHARING_V2;
2240: x_return_status := FND_API.G_RET_STS_ERROR;
2241: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2242: p_count => x_msg_count ,
2243: p_data => x_msg_data);
2244: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2245: IBE_Util.Debug('Expected error in IBE_QUOTE_SAVESHARE_V2_PVT.STOPSHARING_V2');

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

2247:
2248: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2249: ROLLBACK TO STOPSHARING_V2;
2250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2251: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2252: p_count => x_msg_count ,
2253: p_data => x_msg_data);
2254: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2255: IBE_Util.Debug('Unexpected error in IBE_QUOTE_SAVESHARE_V2_PVT.STOPSHARING_V2');

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

2257:
2258: WHEN OTHERS THEN
2259: ROLLBACK TO STOPSHARING_V2;
2260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2261: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2262: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
2263: l_api_name);
2264: END IF;
2265: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 2262: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

2258: WHEN OTHERS THEN
2259: ROLLBACK TO STOPSHARING_V2;
2260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2261: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2262: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
2263: l_api_name);
2264: END IF;
2265: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2266: p_count => x_msg_count ,

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

2261: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2262: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
2263: l_api_name);
2264: END IF;
2265: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2266: p_count => x_msg_count ,
2267: p_data => x_msg_data);
2268: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2269: IBE_Util.Debug('Unknown error in IBE_QUOTE_SAVESHARE_V2_PVT.STOPSHARING_V2');

Line 2343: FND_MSG_PUB.initialize;

2339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2340: END IF;
2341: -- Initialize message list IF p_init_msg_list is set to TRUE.
2342: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2343: FND_MSG_PUB.initialize;
2344: END IF;
2345:
2346: -- Initialize API return status to success
2347: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2454: EXCEPTION
2455: WHEN FND_API.G_EXC_ERROR THEN
2456: ROLLBACK TO ENDWORKING_V2;
2457: x_return_status := FND_API.G_RET_STS_ERROR;
2458: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2459: p_count => x_msg_count ,
2460: p_data => x_msg_data);
2461: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2462: IBE_Util.Debug('Expected error in IBE_QUOTE_SAVESHARE_V2_PVT.ENDWORKING');

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

2464:
2465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2466: ROLLBACK TO ENDWORKING_V2;
2467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2468: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2469: p_count => x_msg_count ,
2470: p_data => x_msg_data);
2471: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2472: IBE_Util.Debug('Unexpected error in IBE_QUOTE_SAVESHARE_V2_PVT.ENDWORKING)');

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

2474:
2475: WHEN OTHERS THEN
2476: ROLLBACK TO ENDWORKING_V2;
2477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2478: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2479: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
2480: l_api_name);
2481: END IF;
2482: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 2479: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

2475: WHEN OTHERS THEN
2476: ROLLBACK TO ENDWORKING_V2;
2477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2478: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2479: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
2480: l_api_name);
2481: END IF;
2482: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2483: p_count => x_msg_count ,

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

2478: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2479: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
2480: l_api_name);
2481: END IF;
2482: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2483: p_count => x_msg_count ,
2484: p_data => x_msg_data);
2485: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2486: IBE_Util.Debug('Unknown error in IBE_QUOTE_SAVESHARE_V2_PVT.ENDWORKING');

Line 2538: FND_MSG_PUB.initialize;

2534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2535: END IF;
2536: -- Initialize message list IF p_init_msg_list is set to TRUE.
2537: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2538: FND_MSG_PUB.initialize;
2539: END IF;
2540:
2541: -- Initialize API return status to success
2542: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2606:
2607: WHEN FND_API.G_EXC_ERROR THEN
2608: ROLLBACK TO STOPSHARING_V2;
2609: x_return_status := FND_API.G_RET_STS_ERROR;
2610: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2611: p_count => x_msg_count ,
2612: p_data => x_msg_data);
2613: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2614: IBE_Util.Debug('Expected error in IBE_QUOTE_SAVESHARE_V2_PVT.SHAREREADONLY_V2');

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

2616:
2617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2618: ROLLBACK TO STOPSHARING_V2;
2619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2620: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2621: p_count => x_msg_count ,
2622: p_data => x_msg_data);
2623: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2624: IBE_Util.Debug('Unexpected error in IBE_QUOTE_SAVESHARE_V2_PVT.SHAREREADONLY_V2');

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

2626:
2627: WHEN OTHERS THEN
2628: ROLLBACK TO STOPSHARING_V2;
2629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2630: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2631: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
2632: l_api_name);
2633: END IF;
2634: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 2631: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

2627: WHEN OTHERS THEN
2628: ROLLBACK TO STOPSHARING_V2;
2629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2630: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2631: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
2632: l_api_name);
2633: END IF;
2634: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2635: p_count => x_msg_count ,

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

2630: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2631: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
2632: l_api_name);
2633: END IF;
2634: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2635: p_count => x_msg_count ,
2636: p_data => x_msg_data);
2637: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2638: IBE_Util.Debug('Unknown error in IBE_QUOTE_SAVESHARE_V2_PVT.SHAREREADONLY_V2');

Line 2714: FND_MSG_PUB.initialize;

2710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2711: END IF;
2712: -- Initialize message list IF p_init_msg_list is set to TRUE.
2713: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2714: FND_MSG_PUB.initialize;
2715: END IF;
2716:
2717: -- Initialize API return status to success
2718: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2860: EXCEPTION
2861: WHEN FND_API.G_EXC_ERROR THEN
2862: ROLLBACK TO DELETERECIPIENT_V2;
2863: x_return_status := FND_API.G_RET_STS_ERROR;
2864: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2865: p_count => x_msg_count ,
2866: p_data => x_msg_data);
2867: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2868: IBE_Util.Debug('Expected error in IBE_QUOTE_SAVESHARE_V2_PVT.DELETE_RECIPIENT()');

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

2870:
2871: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2872: ROLLBACK TO DELETERECIPIENT_V2;
2873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2874: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2875: p_count => x_msg_count ,
2876: p_data => x_msg_data);
2877: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2878: IBE_Util.Debug('Unexpected error in IBE_QUOTE_SAVESHARE_V2_PVT.DELETE_RECIPIENT()');

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

2880:
2881: WHEN OTHERS THEN
2882: ROLLBACK TO DELETERECIPIENT_V2;
2883: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2884: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2885: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
2886: l_api_name);
2887: END IF;
2888: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 2885: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

2881: WHEN OTHERS THEN
2882: ROLLBACK TO DELETERECIPIENT_V2;
2883: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2884: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2885: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
2886: l_api_name);
2887: END IF;
2888: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2889: p_count => x_msg_count ,

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

2884: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2885: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
2886: l_api_name);
2887: END IF;
2888: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2889: p_count => x_msg_count ,
2890: p_data => x_msg_data);
2891: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2892: IBE_Util.Debug('Unknown error in IBE_QUOTE_SAVESHARE_V2_PVT.DELETE_RECIPIENT()');

Line 2981: FND_Msg_Pub.initialize;

2977:
2978: -- Initialize message list if p_init_msg_list is set to TRUE.
2979:
2980: IF FND_API.To_Boolean( p_init_msg_list ) THEN
2981: FND_Msg_Pub.initialize;
2982: END IF;
2983:
2984: -- Initialize API return status to success
2985: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3033: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3034: IBE_Util.Debug('RECIPIENT access level: ' || l_access_level);
3035: END IF;
3036: if (l_access_level is null) then
3037: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
3038: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_USERACCESS');
3039: FND_Msg_Pub.Add;
3040: END IF;
3041: -- need to raise an error that the user no longer has access to this cart

Line 3039: FND_Msg_Pub.Add;

3035: END IF;
3036: if (l_access_level is null) then
3037: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
3038: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_USERACCESS');
3039: FND_Msg_Pub.Add;
3040: END IF;
3041: -- need to raise an error that the user no longer has access to this cart
3042: RAISE FND_API.G_EXC_ERROR;
3043: end if;

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

3046: ------------ DETERMINE WHICH VALIDATIONS TO DO BASED ON OP CODE ------------------------------
3047: -- owner only operations
3048: if (p_operation_code in (OP_APPEND, OP_NAME_CART, OP_SAVE_CART_AND_RECIPIENTS)) then
3049: if (l_is_owner = FND_API.G_FALSE) then
3050: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
3051: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_PRIVILEGE');
3052: FND_Msg_Pub.Add;
3053: END IF;
3054: -- raise an error that the user does not have this privilege

Line 3052: FND_Msg_Pub.Add;

3048: if (p_operation_code in (OP_APPEND, OP_NAME_CART, OP_SAVE_CART_AND_RECIPIENTS)) then
3049: if (l_is_owner = FND_API.G_FALSE) then
3050: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
3051: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_PRIVILEGE');
3052: FND_Msg_Pub.Add;
3053: END IF;
3054: -- raise an error that the user does not have this privilege
3055: RAISE FND_API.G_EXC_ERROR;
3056: end if;

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

3059: end if;
3060: -- owner or admin operations
3061: elsif (p_operation_code in (OP_STOP_SHARING, OP_DELETE_CART)) then
3062: if ((l_is_owner = FND_API.G_FALSE) and (l_access_level <> 'A')) then
3063: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
3064: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_PRIVILEGE');
3065: FND_Msg_Pub.Add;
3066: END IF;
3067: -- raise an error that the user does not have this privilege

Line 3065: FND_Msg_Pub.Add;

3061: elsif (p_operation_code in (OP_STOP_SHARING, OP_DELETE_CART)) then
3062: if ((l_is_owner = FND_API.G_FALSE) and (l_access_level <> 'A')) then
3063: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
3064: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_PRIVILEGE');
3065: FND_Msg_Pub.Add;
3066: END IF;
3067: -- raise an error that the user does not have this privilege
3068: RAISE FND_API.G_EXC_ERROR;
3069: end if;

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

3121: or ((p_quote_access_tbl(i).operation_code = 'UPDATE')
3122: and (p_quote_access_tbl(i).update_privilege_type_code is not null)
3123: and (p_quote_access_tbl(i).update_privilege_type_code <> FND_API.G_MISS_CHAR)
3124: and (p_quote_access_tbl(i).update_privilege_type_code <> l_db_quote_access_tbl(i).update_privilege_type_code))) then
3125: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
3126: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_PRIVILEGE');
3127: FND_Msg_Pub.Add;
3128: END IF;
3129: RAISE FND_API.G_EXC_ERROR;

Line 3127: FND_Msg_Pub.Add;

3123: and (p_quote_access_tbl(i).update_privilege_type_code <> FND_API.G_MISS_CHAR)
3124: and (p_quote_access_tbl(i).update_privilege_type_code <> l_db_quote_access_tbl(i).update_privilege_type_code))) then
3125: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
3126: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_PRIVILEGE');
3127: FND_Msg_Pub.Add;
3128: END IF;
3129: RAISE FND_API.G_EXC_ERROR;
3130: end if;
3131: end if; -- end check onlynotify

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

3151: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3152: IBE_UTIL.DEBUG('timestamps do not match, but user was the last to update the row so allowing it to go through');
3153: end if;
3154: else
3155: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
3156: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_MEMBERS_OUT_OF_SYNC');
3157: FND_Msg_Pub.Add;
3158: END IF;
3159: -- need a new error msg that the row has been updated by another user and to try again

Line 3157: FND_Msg_Pub.Add;

3153: end if;
3154: else
3155: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
3156: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_MEMBERS_OUT_OF_SYNC');
3157: FND_Msg_Pub.Add;
3158: END IF;
3159: -- need a new error msg that the row has been updated by another user and to try again
3160: RAISE FND_API.G_EXC_ERROR;
3161: end if;

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

3171:
3172: EXCEPTION
3173: WHEN FND_API.G_EXC_ERROR THEN
3174: x_return_status := FND_API.G_RET_STS_ERROR;
3175: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
3176: p_count => x_msg_count ,
3177: p_data => x_msg_data);
3178: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3179: IBE_Util.Debug('End IBE_Quote_Misc_pvt.validate_share_update: expected error');

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

3179: IBE_Util.Debug('End IBE_Quote_Misc_pvt.validate_share_update: expected error');
3180: END IF;
3181: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3183: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
3184: p_count => x_msg_count ,
3185: p_data => x_msg_data);
3186: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3187: IBE_Util.Debug('End IBE_Quote_Misc_pvt.validate_share_update: unexpected error');

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

3186: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3187: IBE_Util.Debug('End IBE_Quote_Misc_pvt.validate_share_update: unexpected error');
3188: END IF;
3189: WHEN OTHERS THEN
3190: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
3191: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
3192: l_api_name);
3193: END IF;
3194: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 3191: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

3187: IBE_Util.Debug('End IBE_Quote_Misc_pvt.validate_share_update: unexpected error');
3188: END IF;
3189: WHEN OTHERS THEN
3190: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
3191: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
3192: l_api_name);
3193: END IF;
3194: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
3195: p_count => x_msg_count ,

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

3190: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
3191: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
3192: l_api_name);
3193: END IF;
3194: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
3195: p_count => x_msg_count ,
3196: p_data => x_msg_data);
3197: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3198: IBE_Util.Debug('End IBE_Quote_Misc_pvt.validate_share_update: other exception');