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

Line 426: FND_Msg_Pub.initialize;

422: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
423: END IF;
424: -- Initialize message list if p_init_msg_list is set to TRUE.
425: IF FND_API.To_Boolean(p_init_msg_list) THEN
426: FND_Msg_Pub.initialize;
427: END IF;
428: -- Initialize API return status to success
429: x_return_status := FND_API.G_RET_STS_SUCCESS;
430: -- API body

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

513: IF FND_API.To_Boolean(p_commit) THEN
514: COMMIT WORK;
515: END IF;
516: -- Standard call to get message count and if count is 1, get message info.
517: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
518: p_count => x_msg_count ,
519: p_data => x_msg_data);
520:
521: EXCEPTION

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

524: ibe_util.debug('Expected error in IBE_QUOTE_SAVE_PVT.header_agreements');
525: END IF;
526: ROLLBACK TO handle_header_agreements_pvt;
527: x_return_status := FND_API.G_RET_STS_ERROR;
528: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
529: p_count => x_msg_count ,
530: p_data => x_msg_data);
531: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
532: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

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

533: ibe_util.debug('Unexpected error in IBE_QUOTE_SAVE_PVT.header_agreements');
534: END IF;
535: ROLLBACK TO handle_header_agreements_pvt;
536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
537: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
538: p_count => x_msg_count ,
539: p_data => x_msg_data);
540: WHEN OTHERS THEN
541: ROLLBACK TO handle_header_agreements_pvt;

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

542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
543: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
544: ibe_util.debug('Unknown error in IBE_QUOTE_SAVE_PVT.header_agreements');
545: END IF;
546: IF FND_Msg_Pub.Check_Msg_Level( FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
547: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
548: L_API_NAME);
549: END IF;
550:

Line 547: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

543: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
544: ibe_util.debug('Unknown error in IBE_QUOTE_SAVE_PVT.header_agreements');
545: END IF;
546: IF FND_Msg_Pub.Check_Msg_Level( FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
547: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
548: L_API_NAME);
549: END IF;
550:
551: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

547: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
548: L_API_NAME);
549: END IF;
550:
551: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
552: p_count => x_msg_count ,
553: p_data => x_msg_data);
554:
555: end header_agreements;

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

613: -- update quote
614: /*A quote header_id is passed in during every update quote operation*/
615: ELSE
616: IF NOT FND_API.To_Boolean(p_auto_update_active_quote) THEN
617: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
618: FND_Message.Set_Name('IBE', 'IBE_SC_QUOTE_NEED_REFRESH');
619: FND_Msg_Pub.Add;
620: END IF;
621:

Line 619: FND_Msg_Pub.Add;

615: ELSE
616: IF NOT FND_API.To_Boolean(p_auto_update_active_quote) THEN
617: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
618: FND_Message.Set_Name('IBE', 'IBE_SC_QUOTE_NEED_REFRESH');
619: FND_Msg_Pub.Add;
620: END IF;
621:
622: RAISE FND_API.G_EXC_ERROR; -- need error message
623: END IF;

Line 1186: FND_Msg_Pub.initialize;

1182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1183: END IF;
1184: -- Initialize message list if p_init_msg_list is set to TRUE.
1185: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1186: FND_Msg_Pub.initialize;
1187: END IF;
1188: -- Initialize API return status to success
1189: x_return_status := FND_API.G_RET_STS_SUCCESS;
1190:

Line 1192: FND_Msg_Pub.initialize;

1188: -- Initialize API return status to success
1189: x_return_status := FND_API.G_RET_STS_SUCCESS;
1190:
1191: IF FND_API.To_Boolean(p_init_msg_list) THEN
1192: FND_Msg_Pub.initialize;
1193: END IF;
1194:
1195: -- API body
1196:

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

1239: COMMIT WORK;
1240: END IF;
1241:
1242: -- Standard call to get message count and if count is 1, get message info.
1243: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1244: p_count => x_msg_count ,
1245: p_data => x_msg_data);
1246: EXCEPTION
1247: WHEN FND_API.G_EXC_ERROR THEN

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

1249: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1250: IBE_UTIL.DEBUG('Expected error in IBE_QUOTE_SAVE_PVT.DeleteSharees');
1251: END IF;
1252: x_return_status := FND_API.G_RET_STS_ERROR;
1253: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1254: p_count => x_msg_count ,
1255: p_data => x_msg_data);
1256:
1257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1259: IBE_UTIL.DEBUG('Unexpected error in IBE_QUOTE_SAVE_PVT.DeleteSharees');
1260: END IF;
1261: ROLLBACK TO DELETESHAREES_pvt;
1262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1263: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1264: p_count => x_msg_count ,
1265: p_data => x_msg_data);
1266: WHEN OTHERS THEN
1267: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

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

1268: IBE_UTIL.DEBUG('Unknown error in IBE_QUOTE_SAVE_PVT.DeleteSharees');
1269: END IF;
1270: ROLLBACK TO DELETESHAREES_pvt;
1271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1272: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1273: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
1274: l_api_name);
1275: END IF;
1276: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 1273: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

1269: END IF;
1270: ROLLBACK TO DELETESHAREES_pvt;
1271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1272: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1273: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
1274: l_api_name);
1275: END IF;
1276: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1277: p_count => x_msg_count ,

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

1272: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1273: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
1274: l_api_name);
1275: END IF;
1276: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1277: p_count => x_msg_count ,
1278: p_data => x_msg_data);
1279: END DeleteSharees;
1280:

Line 1353: FND_Msg_Pub.initialize;

1349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1350: END IF;
1351: -- Initialize message list if p_init_msg_list is set to TRUE.
1352: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1353: FND_Msg_Pub.initialize;
1354: END IF;
1355: -- Initialize API return status to success
1356: x_return_status := FND_API.G_RET_STS_SUCCESS;
1357:

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

1412: --DBMS_OUTPUT.PUT_line('Quote not exists ');
1413: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1414: IBE_UTIL.DEBUG('Quote not exists ');
1415: END IF;
1416: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
1417: FND_Message.Set_Name('IBE', 'IBE_SC_NO_QUOTE_EXIST');
1418: FND_Msg_Pub.Add;
1419: END IF;
1420: RAISE FND_API.G_EXC_ERROR;

Line 1418: FND_Msg_Pub.Add;

1414: IBE_UTIL.DEBUG('Quote not exists ');
1415: END IF;
1416: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
1417: FND_Message.Set_Name('IBE', 'IBE_SC_NO_QUOTE_EXIST');
1418: FND_Msg_Pub.Add;
1419: END IF;
1420: RAISE FND_API.G_EXC_ERROR;
1421: ELSIF (l_quote_status = 'ORDERED') THEN
1422: --DBMS_OUTPUT.PUT_line('Quote ordered ');

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

1422: --DBMS_OUTPUT.PUT_line('Quote ordered ');
1423: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1424: IBE_UTIL.DEBUG('Quote ordered ');
1425: END IF;
1426: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
1427: FND_Message.Set_Name('IBE', 'IBE_SC_QUOTE_IS_ORDERED');
1428: FND_Msg_Pub.Add;
1429: END IF;
1430: RAISE FND_API.G_EXC_ERROR;

Line 1428: FND_Msg_Pub.Add;

1424: IBE_UTIL.DEBUG('Quote ordered ');
1425: END IF;
1426: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
1427: FND_Message.Set_Name('IBE', 'IBE_SC_QUOTE_IS_ORDERED');
1428: FND_Msg_Pub.Add;
1429: END IF;
1430: RAISE FND_API.G_EXC_ERROR;
1431: END IF;
1432: --Removing this validation because this is aleady being done in validate_user_update

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

1590: COMMIT WORK;
1591: END IF;
1592:
1593: -- Standard call to get message count and if count is 1, get message info.
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: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1598: IBE_Util.Debug('End IBE_Quote_Save_pvt.Delete()');

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

1605: END IF;
1606:
1607: ROLLBACK TO DELETE_pvt;
1608: x_return_status := FND_API.G_RET_STS_ERROR;
1609: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1610: p_count => x_msg_count ,
1611: p_data => x_msg_data);
1612: --IBE_Util.Disable_Debug;
1613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1615: IBE_Util.Debug('Unexpected error: End IBE_Quote_Save_pvt.Delete()');
1616: END IF;
1617: ROLLBACK TO DELETE_pvt;
1618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1619: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1620: p_count => x_msg_count ,
1621: p_data => x_msg_data);
1622: -- IBE_Util.Disable_Debug;
1623: WHEN OTHERS THEN

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

1625: IBE_Util.Debug('Unknown error: End IBE_Quote_Save_pvt.Delete()');
1626: END IF;
1627: ROLLBACK TO DELETE_pvt;
1628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1629: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1630: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
1631: l_api_name);
1632: END IF;
1633: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 1630: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

1626: END IF;
1627: ROLLBACK TO DELETE_pvt;
1628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1629: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1630: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
1631: l_api_name);
1632: END IF;
1633: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1634: p_count => x_msg_count ,

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

1629: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1630: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
1631: l_api_name);
1632: END IF;
1633: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1634: p_count => x_msg_count ,
1635: p_data => x_msg_data);
1636: --IBE_Util.Disable_Debug;
1637: END DELETE;

Line 1684: FND_Msg_Pub.initialize;

1680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1681: END IF;
1682: -- Initialize message list if p_init_msg_list is set to TRUE.
1683: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1684: FND_Msg_Pub.initialize;
1685: END IF;
1686: -- Initialize API return status to success
1687: x_return_status := FND_API.G_RET_STS_SUCCESS;
1688:

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

1754: END IF;
1755:
1756: -- Standard call to get message count and if count is 1, get message info.
1757:
1758: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1759: p_count => x_msg_count ,
1760: p_data => x_msg_data);
1761:
1762: EXCEPTION

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

1765: IBE_Util.Debug('Expected error: IBE_Quote_Save_pvt.DeleteAllLines()');
1766: END IF;
1767: ROLLBACK TO DELETEALLLINES_pvt;
1768: x_return_status := FND_API.G_RET_STS_ERROR;
1769: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1770: p_count => x_msg_count ,
1771: p_data => x_msg_data);
1772:
1773: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1776: END IF;
1777:
1778: ROLLBACK TO DELETEALLLINES_pvt;
1779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1780: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1781: p_count => x_msg_count,
1782: p_data => x_msg_data);
1783: WHEN OTHERS THEN
1784: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

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

1787:
1788: ROLLBACK TO DELETEALLLINES_pvt;
1789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1790:
1791: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1792: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
1793: l_api_name);
1794: END IF;
1795: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 1792: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

1788: ROLLBACK TO DELETEALLLINES_pvt;
1789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1790:
1791: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1792: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
1793: l_api_name);
1794: END IF;
1795: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1796: p_count => x_msg_count ,

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

1791: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1792: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
1793: l_api_name);
1794: END IF;
1795: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1796: p_count => x_msg_count ,
1797: p_data => x_msg_data);
1798: END DeleteAllLines;
1799:

Line 2018: FND_Msg_Pub.initialize;

2014: END IF;
2015:
2016: -- Initialize message list if p_init_msg_list is set to TRUE.
2017: IF FND_API.To_Boolean(p_init_msg_list) THEN
2018: FND_Msg_Pub.initialize;
2019: END IF;
2020:
2021: -- Initialize API return status to success
2022: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2713: COMMIT WORK;
2714: END IF;
2715:
2716: -- Standard call to get message count and if count is 1, get message info.
2717: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2718: p_count => x_msg_count ,
2719: p_data => x_msg_data);
2720:
2721: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

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

2730: END IF;
2731:
2732: ROLLBACK TO AddItemsToCartorig_pvt;
2733: x_return_status := FND_API.G_RET_STS_ERROR;
2734: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2735: p_count => x_msg_count ,
2736: p_data => x_msg_data);
2737: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2738: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

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

2740: END IF;
2741:
2742: ROLLBACK TO AddItemsToCartorig_pvt;
2743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2744: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2745: p_count => x_msg_count ,
2746: p_data => x_msg_data);
2747: WHEN OTHERS THEN
2748: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

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

2750: END IF;
2751:
2752: ROLLBACK TO AddItemsToCartorig_pvt;
2753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2754: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2755: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
2756: l_api_name);
2757: END IF;
2758: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 2755: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

2751:
2752: ROLLBACK TO AddItemsToCartorig_pvt;
2753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2754: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2755: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
2756: l_api_name);
2757: END IF;
2758: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2759: p_count => x_msg_count ,

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

2754: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2755: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
2756: l_api_name);
2757: END IF;
2758: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2759: p_count => x_msg_count ,
2760: p_data => x_msg_data);
2761:
2762: END AddItemsToCart_orig;

Line 2960: FND_Msg_Pub.initialize;

2956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2957: END IF;
2958: -- Initialize message list if p_init_msg_list is set to TRUE.
2959: IF FND_API.To_Boolean( p_init_msg_list ) THEN
2960: FND_Msg_Pub.initialize;
2961: END IF;
2962:
2963: -- Initialize API return status to success
2964: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3121: IF (l_config_header_id is NULL) THEN
3122: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3123: IBE_Util.Debug('Error in CZ_CF_API.Validate:Printing the terminate string: '||lx_xml_from_validate);
3124: END IF;
3125: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
3126: FND_Message.Set_Name('IBE','IBE_DSP_GENERIC_ERROR_TXT');
3127: FND_Message.Set_Token('IBE_DSP_GENERIC_ERROR_TXT',lx_xml_from_validate);
3128: FND_Msg_Pub.Add;
3129: END IF;

Line 3128: FND_Msg_Pub.Add;

3124: END IF;
3125: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
3126: FND_Message.Set_Name('IBE','IBE_DSP_GENERIC_ERROR_TXT');
3127: FND_Message.Set_Token('IBE_DSP_GENERIC_ERROR_TXT',lx_xml_from_validate);
3128: FND_Msg_Pub.Add;
3129: END IF;
3130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3131: END IF;
3132:

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

3193: END IF;
3194:
3195: ROLLBACK TO ADDITEMSTOCART_pvt;
3196: x_return_status := FND_API.G_RET_STS_ERROR;
3197: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
3198: p_count => x_msg_count ,
3199: p_data => x_msg_data);
3200:
3201: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

3203: IBE_Util.Debug('Unexpected error: IBE_Quote_Save_pvt.AddItemsToCart() (new one)');
3204: END IF;
3205: ROLLBACK TO ADDITEMSTOCART_pvt;
3206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3207: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
3208: p_count => x_msg_count ,
3209: p_data => x_msg_data);
3210:
3211: WHEN OTHERS THEN

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

3213: IBE_Util.Debug('Unknown error: IBE_Quote_Save_pvt.AddItemsToCart) (new one)');
3214: END IF;
3215: ROLLBACK TO ADDITEMSTOCART_pvt;
3216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3217: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
3218: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
3219: l_api_name);
3220: END IF;
3221: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 3218: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

3214: END IF;
3215: ROLLBACK TO ADDITEMSTOCART_pvt;
3216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3217: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
3218: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
3219: l_api_name);
3220: END IF;
3221: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
3222: p_count => x_msg_count ,

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

3217: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
3218: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
3219: l_api_name);
3220: END IF;
3221: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
3222: p_count => x_msg_count ,
3223: p_data => x_msg_data);
3224: END AddItemsToCart;
3225:

Line 3448: FND_Msg_Pub.initialize;

3444: END IF;
3445:
3446: -- Initialize message list if p_init_msg_list is set to TRUE.
3447: IF FND_API.To_Boolean(p_init_msg_list) THEN
3448: FND_Msg_Pub.initialize;
3449: END IF;
3450:
3451: -- Initialize API return status to success
3452: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3510: COMMIT WORK;
3511: END IF;
3512:
3513: -- Standard call to get message count and if count is 1, get message info.
3514: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
3515: p_count => x_msg_count ,
3516: p_data => x_msg_data);
3517:
3518: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

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

3525: END IF;
3526:
3527: ROLLBACK TO Get_quote_exp_date_pvt;
3528: x_return_status := FND_API.G_RET_STS_ERROR;
3529: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
3530: p_count => x_msg_count ,
3531: p_data => x_msg_data);
3532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3533: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

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

3535: END IF;
3536:
3537: ROLLBACK TO Get_quote_exp_date_pvt;
3538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3539: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
3540: p_count => x_msg_count ,
3541: p_data => x_msg_data);
3542: WHEN OTHERS THEN
3543: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

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

3545: END IF;
3546:
3547: ROLLBACK TO Get_quote_exp_date_pvt;
3548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3549: IF FND_Msg_Pub.Check_Msg_Level( FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
3550: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
3551: L_API_NAME);
3552: END IF;
3553:

Line 3550: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

3546:
3547: ROLLBACK TO Get_quote_exp_date_pvt;
3548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3549: IF FND_Msg_Pub.Check_Msg_Level( FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
3550: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
3551: L_API_NAME);
3552: END IF;
3553:
3554: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

3550: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
3551: L_API_NAME);
3552: END IF;
3553:
3554: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
3555: p_count => x_msg_count ,
3556: p_data => x_msg_data);
3557: End Get_Quote_expiration_date;
3558:

Line 3669: FND_Msg_Pub.initialize;

3665: END IF;
3666:
3667: -- Initialize message list if p_init_msg_list is set to TRUE.
3668: IF FND_API.To_Boolean(p_init_msg_list) THEN
3669: FND_Msg_Pub.initialize;
3670: END IF;
3671: -- Initialize API return status to success
3672: x_return_status := FND_API.G_RET_STS_SUCCESS;
3673:

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

4036: COMMIT WORK;
4037: END IF;
4038:
4039: -- Standard call to get message count and if count is 1, get message info.
4040: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
4041: p_count => lx_msg_count ,
4042: p_data => lx_msg_data);
4043:
4044: EXCEPTION

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

4049:
4050: ROLLBACK TO Req_for_sales_asst_pvt;
4051: x_return_status := FND_API.G_RET_STS_ERROR;
4052: Set_Last_Update_Date(p_quote_header_id, x_last_update_date);
4053: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
4054: p_count => lx_msg_count ,
4055: p_data => lx_msg_data);
4056: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4057: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

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

4059: END IF;
4060:
4061: ROLLBACK TO Req_for_sales_asst_pvt;
4062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4063: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
4064: p_count => lx_msg_count ,
4065: p_data => lx_msg_data);
4066: WHEN OTHERS THEN
4067: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

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

4070:
4071: ROLLBACK TO Req_for_sales_asst_pvt;
4072: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4073: Set_Last_Update_Date(p_quote_header_id, x_last_update_date);
4074: IF FND_Msg_Pub.Check_Msg_Level( FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
4075: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
4076: L_API_NAME);
4077: END IF;
4078:

Line 4075: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

4071: ROLLBACK TO Req_for_sales_asst_pvt;
4072: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4073: Set_Last_Update_Date(p_quote_header_id, x_last_update_date);
4074: IF FND_Msg_Pub.Check_Msg_Level( FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
4075: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
4076: L_API_NAME);
4077: END IF;
4078:
4079: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

4075: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
4076: L_API_NAME);
4077: END IF;
4078:
4079: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
4080: p_count => lx_msg_count ,
4081: p_data => lx_msg_data);
4082:
4083: End request_for_sales_assistance;

Line 4388: FND_Msg_Pub.initialize;

4384: END IF;
4385:
4386: -- Initialize message list if p_init_msg_list is set to TRUE.
4387: IF FND_API.To_Boolean( p_init_msg_list ) THEN
4388: FND_Msg_Pub.initialize;
4389: END IF;
4390:
4391: -- Initialize API return status to success
4392: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

4451: p_Qte_Header_Rec.party_id,
4452: p_Qte_Header_Rec.cust_account_id);
4453: --Raise an error f the above validation failed
4454: IF(l_is_quote_usable = FND_API.G_FALSE) THEN
4455: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4456: FND_Message.Set_Name('IBE', 'IBE_SC_CART_EXPIRED');
4457: FND_Msg_Pub.Add;
4458: END IF;
4459: RAISE FND_API.G_EXC_ERROR;

Line 4457: FND_Msg_Pub.Add;

4453: --Raise an error f the above validation failed
4454: IF(l_is_quote_usable = FND_API.G_FALSE) THEN
4455: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4456: FND_Message.Set_Name('IBE', 'IBE_SC_CART_EXPIRED');
4457: FND_Msg_Pub.Add;
4458: END IF;
4459: RAISE FND_API.G_EXC_ERROR;
4460: END IF;
4461: Default_Header_Record( p_qte_header_rec => p_qte_header_rec

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

4530: l_privilege_type_code := IBE_Quote_Misc_pvt.GetShareeprivilege(l_qte_header_rec.quote_header_id
4531: ,p_sharee_Number);
4532: IF ((l_privilege_type_code <> 'A')
4533: and (l_privilege_type_code <> 'F' )) THEN
4534: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4535: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_PRIVILEGE');
4536: FND_Msg_Pub.Add;
4537: END IF;
4538: RAISE FND_API.G_EXC_ERROR; -- need error message

Line 4536: FND_Msg_Pub.Add;

4532: IF ((l_privilege_type_code <> 'A')
4533: and (l_privilege_type_code <> 'F' )) THEN
4534: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4535: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_PRIVILEGE');
4536: FND_Msg_Pub.Add;
4537: END IF;
4538: RAISE FND_API.G_EXC_ERROR; -- need error message
4539: END IF;
4540:

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

4539: END IF;
4540:
4541: IF ( l_privilege_type_code <> 'A'
4542: and FND_API.To_Boolean(p_changeowner) )THEN
4543: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4544: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_PRIVILEGE');
4545: FND_Msg_Pub.Add;
4546: END IF;
4547: RAISE FND_API.G_EXC_ERROR; -- need error message

Line 4545: FND_Msg_Pub.Add;

4541: IF ( l_privilege_type_code <> 'A'
4542: and FND_API.To_Boolean(p_changeowner) )THEN
4543: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4544: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_PRIVILEGE');
4545: FND_Msg_Pub.Add;
4546: END IF;
4547: RAISE FND_API.G_EXC_ERROR; -- need error message
4548: END IF;
4549: END IF; -- p_sharee_number is not null

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

4687: END IF;
4688: END IF;
4689: EXCEPTION
4690: When OTHERS THEN
4691: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4692: FND_MESSAGE.set_name('IBE', 'IBE_UPDATE_MSITE_HDR_ERR');
4693: FND_MSG_PUB.add;
4694: END IF;
4695: RAISE FND_API.G_EXC_ERROR;

Line 4693: FND_MSG_PUB.add;

4689: EXCEPTION
4690: When OTHERS THEN
4691: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4692: FND_MESSAGE.set_name('IBE', 'IBE_UPDATE_MSITE_HDR_ERR');
4693: FND_MSG_PUB.add;
4694: END IF;
4695: RAISE FND_API.G_EXC_ERROR;
4696: END;
4697:

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

4703: IBE_Quote_Misc_pvt.Get_Active_Quote_ID
4704: (p_party_id => x_qte_header_rec.party_id
4705: ,p_cust_account_id => x_qte_header_rec.cust_account_id
4706: ,p_only_max => FALSE) then
4707: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4708: FND_Message.Set_Name('IBE', 'IBE_SC_QUOTE_NEED_REFRESH');
4709: FND_Msg_Pub.Add;
4710: END IF;
4711: RAISE FND_API.G_EXC_ERROR; -- need error message

Line 4709: FND_Msg_Pub.Add;

4705: ,p_cust_account_id => x_qte_header_rec.cust_account_id
4706: ,p_only_max => FALSE) then
4707: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4708: FND_Message.Set_Name('IBE', 'IBE_SC_QUOTE_NEED_REFRESH');
4709: FND_Msg_Pub.Add;
4710: END IF;
4711: RAISE FND_API.G_EXC_ERROR; -- need error message
4712: END IF;
4713: END IF;*/

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

4771: l_hd_payment_tbl(I).last_update_date :=
4772: IBE_Quote_Misc_pvt.getQuoteLastUpdateDate(l_qte_header_rec.quote_header_id); -- Bug# 1955991
4773: */
4774: /* Bug#1955991
4775: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4776: FND_Message.Set_Name('IBE', 'IBE_QUOTE_HDR_PMT_RCRD_EXISTS');
4777: FND_Msg_Pub.Add;
4778: END IF;
4779: RAISE FND_API.G_EXC_ERROR;

Line 4777: FND_Msg_Pub.Add;

4773: */
4774: /* Bug#1955991
4775: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4776: FND_Message.Set_Name('IBE', 'IBE_QUOTE_HDR_PMT_RCRD_EXISTS');
4777: FND_Msg_Pub.Add;
4778: END IF;
4779: RAISE FND_API.G_EXC_ERROR;
4780: */
4781: END IF;

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

4782: END IF;
4783: END LOOP;
4784: /* Bug#1955991
4785: IF l_count > 1 THEN -- Trying to create more than one header payment
4786: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4787: FND_Message.Set_Name('IBE', 'IBE_QUOTE_HDR_PMT_RCRD_EXISTS');
4788: FND_Msg_Pub.Add;
4789: END IF;
4790: RAISE FND_API.G_EXC_ERROR;

Line 4788: FND_Msg_Pub.Add;

4784: /* Bug#1955991
4785: IF l_count > 1 THEN -- Trying to create more than one header payment
4786: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4787: FND_Message.Set_Name('IBE', 'IBE_QUOTE_HDR_PMT_RCRD_EXISTS');
4788: FND_Msg_Pub.Add;
4789: END IF;
4790: RAISE FND_API.G_EXC_ERROR;
4791: END IF;
4792: */

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

5013: COMMIT WORK;
5014: END IF;
5015:
5016: -- Standard call to get message count and if count is 1, get message info.
5017: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
5018: p_count => x_msg_count ,
5019: p_data => x_msg_data);
5020: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5021: IBE_Util.Debug('Normal End IBE_Quote_Save_pvt.Save()');

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

5028: END IF;
5029: ROLLBACK TO SAVE_pvt;
5030: x_return_status := FND_API.G_RET_STS_ERROR;
5031: Set_Last_Update_Date(l_qte_header_rec.quote_header_id, x_last_update_date);
5032: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
5033: p_count => x_msg_count ,
5034: p_data => x_msg_data);
5035: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5036: IBE_Util.Debug('Unexpected error IBE_Quote_Save_pvt.Save()');

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

5038: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5039: ROLLBACK TO SAVE_pvt;
5040: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5041: Set_Last_Update_Date(l_qte_header_rec.quote_header_id, x_last_update_date);
5042: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
5043: p_count => x_msg_count ,
5044: p_data => x_msg_data);
5045: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5046: IBE_Util.Debug('Unknown exception End IBE_Quote_Save_pvt.Save()');

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

5048: WHEN OTHERS THEN
5049: ROLLBACK TO SAVE_pvt;
5050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5051: Set_Last_Update_Date(l_qte_header_rec.quote_header_id, x_last_update_date);
5052: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
5053: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
5054: l_api_name);
5055: END IF;
5056: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 5053: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

5049: ROLLBACK TO SAVE_pvt;
5050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5051: Set_Last_Update_Date(l_qte_header_rec.quote_header_id, x_last_update_date);
5052: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
5053: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
5054: l_api_name);
5055: END IF;
5056: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
5057: p_count => x_msg_count ,

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

5052: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
5053: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
5054: l_api_name);
5055: END IF;
5056: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
5057: p_count => x_msg_count ,
5058: p_data => x_msg_data);
5059: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5060: IBE_Util.Debug('End IBE_Quote_Save_pvt.Save()');

Line 5173: FND_Msg_Pub.initialize;

5169:
5170: -- Initialize message list if p_init_msg_list is set to TRUE.
5171:
5172: IF FND_API.To_Boolean( p_init_msg_list ) THEN
5173: FND_Msg_Pub.initialize;
5174: END IF;
5175: -- Initialize API return status to success
5176: x_return_status := FND_API.G_RET_STS_SUCCESS;
5177:

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

5321: COMMIT WORK;
5322: END IF;
5323:
5324: -- Standard call to get message count and if count is 1, get message info.
5325: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
5326: p_count => x_msg_count ,
5327: p_data => x_msg_data);
5328: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5329: IBE_Util.Debug('End IBE_Quote_Save_pvt.UpdateQuoteForSharee()');

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

5332: EXCEPTION
5333: WHEN FND_API.G_EXC_ERROR THEN
5334: ROLLBACK TO UpdateQuoteForSharee_pvt;
5335: x_return_status := FND_API.G_RET_STS_ERROR;
5336: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
5337: p_count => x_msg_count ,
5338: p_data => x_msg_data);
5339: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5340: IBE_Util.Debug('End IBE_Quote_Save_pvt.UpdateQuoteForSharee()');

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

5342: -- IBE_Util.Disable_Debug;
5343: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5344: ROLLBACK TO UpdateQuoteForSharee_pvt;
5345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5346: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
5347: p_count => x_msg_count ,
5348: p_data => x_msg_data);
5349: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5350: IBE_Util.Debug('End IBE_Quote_Save_pvt.UpdateQuoteForSharee()');

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

5353: WHEN OTHERS THEN
5354: ROLLBACK TO UpdateQuoteForSharee_pvt;
5355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5356:
5357: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
5358: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
5359: l_api_name);
5360: END IF;
5361:

Line 5358: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

5354: ROLLBACK TO UpdateQuoteForSharee_pvt;
5355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5356:
5357: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
5358: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
5359: l_api_name);
5360: END IF;
5361:
5362: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

5358: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
5359: l_api_name);
5360: END IF;
5361:
5362: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
5363: p_count => x_msg_count ,
5364: p_data => x_msg_data);
5365: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5366: IBE_Util.Debug('End IBE_Quote_Save_pvt.UpdateQuoteForSharee()');

Line 5453: FND_Msg_Pub.initialize;

5449: END IF;
5450:
5451: -- Initialize message list if p_init_msg_list is set to TRUE.
5452: IF FND_API.To_Boolean(p_init_msg_list) THEN
5453: FND_Msg_Pub.initialize;
5454: END IF;
5455:
5456: -- Initialize API return status to success
5457: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

5786: COMMIT WORK;
5787: END IF;
5788:
5789: -- Standard call to get message count and if count is 1, get message info.
5790: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
5791: p_count => x_msg_count ,
5792: p_data => x_msg_data);
5793: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5794: IBE_Util.Debug('End IBE_Quote_Save_pvt.getHdrDefaultValues()');

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

5798: EXCEPTION
5799: WHEN FND_API.G_EXC_ERROR THEN
5800: ROLLBACK TO getHdrDefaultValues_PVT;
5801: x_return_status := FND_API.G_RET_STS_ERROR;
5802: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
5803: p_count => x_msg_count ,
5804: p_data => x_msg_data);
5805: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5806: ROLLBACK TO getHdrDefaultValues_PVT;

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

5804: p_data => x_msg_data);
5805: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5806: ROLLBACK TO getHdrDefaultValues_PVT;
5807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5808: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
5809: p_count => x_msg_count ,
5810: p_data => x_msg_data);
5811: WHEN OTHERS THEN
5812: ROLLBACK TO getHdrDefaultValues_PVT;

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

5810: p_data => x_msg_data);
5811: WHEN OTHERS THEN
5812: ROLLBACK TO getHdrDefaultValues_PVT;
5813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5814: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
5815: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
5816: l_api_name);
5817: END IF;
5818: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 5815: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

5811: WHEN OTHERS THEN
5812: ROLLBACK TO getHdrDefaultValues_PVT;
5813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5814: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
5815: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
5816: l_api_name);
5817: END IF;
5818: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
5819: p_count => x_msg_count ,

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

5814: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
5815: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
5816: l_api_name);
5817: END IF;
5818: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
5819: p_count => x_msg_count ,
5820: p_data => x_msg_data);
5821: END getHdrDefaultValues;
5822:

Line 5902: FND_Msg_Pub.initialize;

5898: END IF;
5899:
5900: -- Initialize message list if p_init_msg_list is set to TRUE.
5901: IF FND_API.To_Boolean(p_init_msg_list) THEN
5902: FND_Msg_Pub.initialize;
5903: END IF;
5904:
5905: -- Initialize API return status to success
5906: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

6102: COMMIT WORK;
6103: END IF;
6104:
6105: -- Standard call to get message count and if count is 1, get message info.
6106: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6107: p_count => x_msg_count ,
6108: p_data => x_msg_data);
6109: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
6110: IBE_Util.Debug('End IBE_Quote_Save_pvt.getHdrDefaultAddress()');

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

6114: EXCEPTION
6115: WHEN FND_API.G_EXC_ERROR THEN
6116: ROLLBACK TO getHdrDefaultAddress_pvt;
6117: x_return_status := FND_API.G_RET_STS_ERROR;
6118: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6119: p_count => x_msg_count ,
6120: p_data => x_msg_data);
6121: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6122: ROLLBACK TO getHdrDefaultAddress_pvt;

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

6120: p_data => x_msg_data);
6121: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6122: ROLLBACK TO getHdrDefaultAddress_pvt;
6123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6124: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6125: p_count => x_msg_count ,
6126: p_data => x_msg_data);
6127: WHEN OTHERS THEN
6128: ROLLBACK TO getHdrDefaultAddress_pvt;

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

6126: p_data => x_msg_data);
6127: WHEN OTHERS THEN
6128: ROLLBACK TO getHdrDefaultAddress_pvt;
6129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6130: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
6131: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
6132: l_api_name);
6133: END IF;
6134: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 6131: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

6127: WHEN OTHERS THEN
6128: ROLLBACK TO getHdrDefaultAddress_pvt;
6129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6130: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
6131: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
6132: l_api_name);
6133: END IF;
6134: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6135: p_count => x_msg_count ,

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

6130: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
6131: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
6132: l_api_name);
6133: END IF;
6134: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6135: p_count => x_msg_count ,
6136: p_data => x_msg_data);
6137:
6138: end getHdrDefaultAddress;

Line 6206: FND_Msg_Pub.initialize;

6202: END IF;
6203:
6204: -- Initialize message list if p_init_msg_list is set to TRUE.
6205: IF FND_API.To_Boolean(p_init_msg_list) THEN
6206: FND_Msg_Pub.initialize;
6207: END IF;
6208:
6209: -- Initialize API return status to success
6210: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

6344: COMMIT WORK;
6345: END IF;
6346:
6347: -- Standard call to get message count and if count is 1, get message info.
6348: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6349: p_count => x_msg_count ,
6350: p_data => x_msg_data);
6351: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
6352: IBE_Util.Debug('End IBE_Quote_Save_pvt.getHdrDefaultShipMethod()');

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

6357: EXCEPTION
6358: WHEN FND_API.G_EXC_ERROR THEN
6359: ROLLBACK TO getHdrDefaultShipMethod_pvt;
6360: x_return_status := FND_API.G_RET_STS_ERROR;
6361: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6362: p_count => x_msg_count ,
6363: p_data => x_msg_data);
6364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6365: ROLLBACK TO getHdrDefaultShipMethod_pvt;

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

6363: p_data => x_msg_data);
6364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6365: ROLLBACK TO getHdrDefaultShipMethod_pvt;
6366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6367: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6368: p_count => x_msg_count ,
6369: p_data => x_msg_data);
6370: WHEN OTHERS THEN
6371: ROLLBACK TO getHdrDefaultShipMethod_pvt;

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

6369: p_data => x_msg_data);
6370: WHEN OTHERS THEN
6371: ROLLBACK TO getHdrDefaultShipMethod_pvt;
6372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6373: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
6374: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
6375: l_api_name);
6376: END IF;
6377: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 6374: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

6370: WHEN OTHERS THEN
6371: ROLLBACK TO getHdrDefaultShipMethod_pvt;
6372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6373: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
6374: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
6375: l_api_name);
6376: END IF;
6377: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6378: p_count => x_msg_count ,

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

6373: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
6374: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
6375: l_api_name);
6376: END IF;
6377: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6378: p_count => x_msg_count ,
6379: p_data => x_msg_data);
6380: end getHdrDefaultShipMethod;
6381:

Line 6458: FND_Msg_Pub.initialize;

6454: END IF;
6455:
6456: -- Initialize message list if p_init_msg_list is set to TRUE.
6457: IF FND_API.To_Boolean(p_init_msg_list) THEN
6458: FND_Msg_Pub.initialize;
6459: END IF;
6460:
6461: -- Initialize API return status to success
6462: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

6638: COMMIT WORK;
6639: END IF;
6640:
6641: -- Standard call to get message count and if count is 1, get message info.
6642: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6643: p_count => x_msg_count ,
6644: p_data => x_msg_data);
6645: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
6646: IBE_Util.Debug('End IBE_Quote_Save_pvt.getHdrDefaultPaymentMethod()');

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

6650: EXCEPTION
6651: WHEN FND_API.G_EXC_ERROR THEN
6652: ROLLBACK TO getHdrDefPmtMethod_pvt;
6653: x_return_status := FND_API.G_RET_STS_ERROR;
6654: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6655: p_count => x_msg_count ,
6656: p_data => x_msg_data);
6657: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6658: ROLLBACK TO getHdrDefPmtMethod_pvt;

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

6656: p_data => x_msg_data);
6657: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6658: ROLLBACK TO getHdrDefPmtMethod_pvt;
6659: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6660: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6661: p_count => x_msg_count ,
6662: p_data => x_msg_data);
6663: WHEN OTHERS THEN
6664: ROLLBACK TO getHdrDefPmtMethod_pvt;

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

6662: p_data => x_msg_data);
6663: WHEN OTHERS THEN
6664: ROLLBACK TO getHdrDefPmtMethod_pvt;
6665: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6666: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
6667: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
6668: l_api_name);
6669: END IF;
6670: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 6667: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

6663: WHEN OTHERS THEN
6664: ROLLBACK TO getHdrDefPmtMethod_pvt;
6665: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6666: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
6667: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
6668: l_api_name);
6669: END IF;
6670: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6671: p_count => x_msg_count ,

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

6666: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
6667: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
6668: l_api_name);
6669: END IF;
6670: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6671: p_count => x_msg_count ,
6672: p_data => x_msg_data);
6673: end getHdrDefaultPaymentMethod;
6674:

Line 6721: FND_Msg_Pub.initialize;

6717: END IF;
6718:
6719: -- Initialize message list if p_init_msg_list is set to TRUE.
6720: IF FND_API.To_Boolean(p_init_msg_list) THEN
6721: FND_Msg_Pub.initialize;
6722: END IF;
6723:
6724: -- Initialize API return status to success
6725: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

6759: px_hd_Tax_Detail_Tbl(1).tax_exempt_flag := 'S';
6760: end if;
6761:
6762: -- Standard call to get message count and if count is 1, get message info.
6763: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6764: p_count => x_msg_count ,
6765: p_data => x_msg_data);
6766: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
6767: IBE_Util.Debug('End IBE_Quote_Save_pvt.getHdrDefaultTaxExemption()');

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

6771: EXCEPTION
6772: WHEN FND_API.G_EXC_ERROR THEN
6773: ROLLBACK TO getHdrDefTaxExmpt_pvt;
6774: x_return_status := FND_API.G_RET_STS_ERROR;
6775: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6776: p_count => x_msg_count ,
6777: p_data => x_msg_data);
6778: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6779: ROLLBACK TO getHdrDefTaxExmpt_pvt;

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

6777: p_data => x_msg_data);
6778: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6779: ROLLBACK TO getHdrDefTaxExmpt_pvt;
6780: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6781: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6782: p_count => x_msg_count ,
6783: p_data => x_msg_data);
6784: WHEN OTHERS THEN
6785: ROLLBACK TO getHdrDefTaxExmpt_pvt;

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

6783: p_data => x_msg_data);
6784: WHEN OTHERS THEN
6785: ROLLBACK TO getHdrDefTaxExmpt_pvt;
6786: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6787: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
6788: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
6789: l_api_name);
6790: END IF;
6791: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 6788: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

6784: WHEN OTHERS THEN
6785: ROLLBACK TO getHdrDefTaxExmpt_pvt;
6786: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6787: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
6788: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
6789: l_api_name);
6790: END IF;
6791: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6792: p_count => x_msg_count ,

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

6787: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
6788: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
6789: l_api_name);
6790: END IF;
6791: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6792: p_count => x_msg_count ,
6793: p_data => x_msg_data);
6794:
6795: end getHdrDefaultTaxExemption;

Line 6844: FND_Msg_Pub.initialize;

6840: END IF;
6841:
6842: -- Initialize message list if p_init_msg_list is set to TRUE.
6843: IF FND_API.To_Boolean(p_init_msg_list) THEN
6844: FND_Msg_Pub.initialize;
6845: END IF;
6846:
6847: -- Initialize API return status to success
6848: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

6906: COMMIT WORK;
6907: END IF;
6908:
6909: -- Standard call to get message count and if count is 1, get message info.
6910: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6911: p_count => x_msg_count ,
6912: p_data => x_msg_data);
6913: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
6914: IBE_Util.Debug('End IBE_Quote_Save_pvt.getHdrDefaultEndCustomer()');

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

6918: EXCEPTION
6919: WHEN FND_API.G_EXC_ERROR THEN
6920: ROLLBACK TO getHdrDefaultEndCustomer_pvt;
6921: x_return_status := FND_API.G_RET_STS_ERROR;
6922: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6923: p_count => x_msg_count ,
6924: p_data => x_msg_data);
6925: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6926: ROLLBACK TO getHdrDefaultEndCustomer_pvt;

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

6924: p_data => x_msg_data);
6925: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6926: ROLLBACK TO getHdrDefaultEndCustomer_pvt;
6927: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6928: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6929: p_count => x_msg_count ,
6930: p_data => x_msg_data);
6931: WHEN OTHERS THEN
6932: ROLLBACK TO getHdrDefaultEndCustomer_pvt;

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

6930: p_data => x_msg_data);
6931: WHEN OTHERS THEN
6932: ROLLBACK TO getHdrDefaultEndCustomer_pvt;
6933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6934: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
6935: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
6936: l_api_name);
6937: END IF;
6938: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 6935: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

6931: WHEN OTHERS THEN
6932: ROLLBACK TO getHdrDefaultEndCustomer_pvt;
6933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6934: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
6935: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
6936: l_api_name);
6937: END IF;
6938: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6939: p_count => x_msg_count ,

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

6934: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
6935: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
6936: l_api_name);
6937: END IF;
6938: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6939: p_count => x_msg_count ,
6940: p_data => x_msg_data);
6941:
6942: end getHdrDefaultEndCustomer;

Line 6990: FND_Msg_Pub.initialize;

6986: END IF;
6987:
6988: -- Initialize message list if p_init_msg_list is set to TRUE.
6989: IF FND_API.To_Boolean(p_Init_Msg_List) THEN
6990: FND_Msg_Pub.initialize;
6991: END IF;
6992: -- Initialize API return status to success
6993: x_return_status := FND_API.G_RET_STS_SUCCESS;
6994:

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

7111:
7112:
7113:
7114: -- Standard call to get message count and if count is 1, get message info.
7115: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
7116: p_count => x_msg_count ,
7117: p_data => x_msg_data);
7118: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
7119: IBE_Util.Debug('End IBE_Quote_Save_pvt.getHdrDefaultTaxExemption()');

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

7125:
7126: WHEN FND_API.G_EXC_ERROR THEN
7127: ROLLBACK TO CREATECONTRACTFORQUOTE_pvt;
7128: x_return_status := FND_API.G_RET_STS_ERROR;
7129: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
7130: p_count => x_msg_count,
7131: p_data => x_msg_data);
7132:
7133: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

7132:
7133: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7134: ROLLBACK TO CREATECONTRACTFORQUOTE_pvt;
7135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7136: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
7137: p_count => x_msg_count,
7138: p_data => x_msg_data);
7139:
7140: WHEN OTHERS THEN

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

7140: WHEN OTHERS THEN
7141: ROLLBACK TO CREATECONTRACTFORQUOTE_pvt;
7142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7143:
7144: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7145: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
7146: l_api_name);
7147: END IF;
7148:

Line 7145: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

7141: ROLLBACK TO CREATECONTRACTFORQUOTE_pvt;
7142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7143:
7144: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7145: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
7146: l_api_name);
7147: END IF;
7148:
7149: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

7145: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
7146: l_api_name);
7147: END IF;
7148:
7149: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
7150: p_count => x_msg_count,
7151: p_data => x_msg_data);
7152:
7153: END CREATE_CONTRACT_FOR_QUOTE;

Line 7263: FND_Msg_Pub.initialize;

7259: END IF;
7260:
7261: -- Initialize message list if p_init_msg_list is set to TRUE.
7262: IF FND_API.To_Boolean(p_init_msg_list) THEN
7263: FND_Msg_Pub.initialize;
7264: END IF;
7265: -- Initialize API return status to success
7266: x_return_status := FND_API.G_RET_STS_SUCCESS;
7267:

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

7469: END IF;
7470: x_quote_header_id := lx_quote_header_id;
7471:
7472: -- Standard call to get message count and if count is 1, get message info.
7473: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
7474: p_count => x_msg_count ,
7475: p_data => x_msg_data);
7476: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
7477: IBE_Util.Debug('End IBE_Quote_Save_pvt.Duplicate_cart');

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

7483:
7484: WHEN FND_API.G_EXC_ERROR THEN
7485: ROLLBACK TO Duplicate_Cart;
7486: x_return_status := FND_API.G_RET_STS_ERROR;
7487: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
7488: p_count => x_msg_count,
7489: p_data => x_msg_data);
7490:
7491: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

7490:
7491: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7492: ROLLBACK TO Duplicate_Cart;
7493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7494: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
7495: p_count => x_msg_count,
7496: p_data => x_msg_data);
7497:
7498: WHEN OTHERS THEN

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

7498: WHEN OTHERS THEN
7499: ROLLBACK TO Duplicate_Cart;
7500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7501:
7502: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7503: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
7504: l_api_name);
7505: END IF;
7506:

Line 7503: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

7499: ROLLBACK TO Duplicate_Cart;
7500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7501:
7502: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7503: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
7504: l_api_name);
7505: END IF;
7506:
7507: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

7503: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
7504: l_api_name);
7505: END IF;
7506:
7507: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
7508: p_count => x_msg_count,
7509: p_data => x_msg_data);
7510:
7511:

Line 7589: FND_Msg_Pub.initialize;

7585: END IF;
7586:
7587: -- Initialize message list if p_init_msg_list is set to TRUE.
7588: IF FND_API.To_Boolean(p_init_msg_list) THEN
7589: FND_Msg_Pub.initialize;
7590: END IF;
7591: -- Initialize API return status to success
7592: x_return_status := FND_API.G_RET_STS_SUCCESS;
7593:

Line 7631: FND_MSG_PUB.Add;

7627: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
7628: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
7629: FND_MESSAGE.Set_Token('ERRNO', 'IB_INSTANCE_LOCKED');
7630: FND_MESSAGE.Set_Token('REASON','This instance is locked cannot reconfigure');
7631: FND_MSG_PUB.Add;
7632: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7633: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
7634: END IF;
7635: RAISE FND_API.G_EXC_ERROR;

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

7628: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
7629: FND_MESSAGE.Set_Token('ERRNO', 'IB_INSTANCE_LOCKED');
7630: FND_MESSAGE.Set_Token('REASON','This instance is locked cannot reconfigure');
7631: FND_MSG_PUB.Add;
7632: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7633: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
7634: END IF;
7635: RAISE FND_API.G_EXC_ERROR;
7636: END IF;

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

7629: FND_MESSAGE.Set_Token('ERRNO', 'IB_INSTANCE_LOCKED');
7630: FND_MESSAGE.Set_Token('REASON','This instance is locked cannot reconfigure');
7631: FND_MSG_PUB.Add;
7632: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7633: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
7634: END IF;
7635: RAISE FND_API.G_EXC_ERROR;
7636: END IF;
7637: END LOOP;

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

7740: COMMIT WORK;
7741: END IF;
7742:
7743: -- Standard call to get message count and if count is 1, get message info.
7744: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
7745: p_count => x_msg_count ,
7746: p_data => x_msg_data);
7747: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
7748: IBE_Util.Debug('End IBE_Quote_Save_pvt.Reconfigure_from_ib() end');

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

7750: EXCEPTION
7751: WHEN FND_API.G_EXC_ERROR THEN
7752: ROLLBACK TO Reconfigure_From_Ib;
7753: x_return_status := FND_API.G_RET_STS_ERROR;
7754: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
7755: p_count => x_msg_count,
7756: p_data => x_msg_data);
7757:
7758: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

7757:
7758: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7759: ROLLBACK TO Reconfigure_From_Ib;
7760: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7761: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
7762: p_count => x_msg_count,
7763: p_data => x_msg_data);
7764:
7765: WHEN OTHERS THEN

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

7765: WHEN OTHERS THEN
7766: ROLLBACK TO Reconfigure_From_Ib;
7767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7768:
7769: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7770: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
7771: l_api_name);
7772: END IF;
7773:

Line 7770: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

7766: ROLLBACK TO Reconfigure_From_Ib;
7767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7768:
7769: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7770: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
7771: l_api_name);
7772: END IF;
7773:
7774: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

7770: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
7771: l_api_name);
7772: END IF;
7773:
7774: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
7775: p_count => x_msg_count,
7776: p_data => x_msg_data);
7777:
7778: END RECONFIGURE_FROM_IB;

Line 7982: FND_MSG_PUB.initialize;

7978: END IF;
7979:
7980: -- Initialize message list if p_init_msg_list is set to TRUE.
7981: IF FND_API.to_Boolean(p_init_msg_list) THEN
7982: FND_MSG_PUB.initialize;
7983: END IF;
7984:
7985: -- Initialize API return status to success.
7986: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 8025: FND_MSG_PUB.Add;

8021: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
8022: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
8023: FND_MESSAGE.Set_Token('ERRNO', 'IBE_ST_INVALID_OPERATION');
8024: FND_MESSAGE.Set_Token('REASON', 'quote header id is null');
8025: FND_MSG_PUB.Add;
8026: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8027: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
8028: END IF;
8029: RAISE FND_API.G_EXC_ERROR;

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

8022: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
8023: FND_MESSAGE.Set_Token('ERRNO', 'IBE_ST_INVALID_OPERATION');
8024: FND_MESSAGE.Set_Token('REASON', 'quote header id is null');
8025: FND_MSG_PUB.Add;
8026: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8027: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
8028: END IF;
8029: RAISE FND_API.G_EXC_ERROR;
8030: END IF;

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

8023: FND_MESSAGE.Set_Token('ERRNO', 'IBE_ST_INVALID_OPERATION');
8024: FND_MESSAGE.Set_Token('REASON', 'quote header id is null');
8025: FND_MSG_PUB.Add;
8026: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8027: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
8028: END IF;
8029: RAISE FND_API.G_EXC_ERROR;
8030: END IF;
8031:

Line 8049: FND_MSG_PUB.Add;

8045: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
8046: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
8047: FND_MESSAGE.Set_Token('ERRNO', 'IBE_ST_INVALID_OPERATION');
8048: FND_MESSAGE.Set_Token('REASON', 'size of line records does not match size of line quantities');
8049: FND_MSG_PUB.Add;
8050: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8051: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
8052: END IF;
8053: RAISE FND_API.G_EXC_ERROR;

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

8046: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
8047: FND_MESSAGE.Set_Token('ERRNO', 'IBE_ST_INVALID_OPERATION');
8048: FND_MESSAGE.Set_Token('REASON', 'size of line records does not match size of line quantities');
8049: FND_MSG_PUB.Add;
8050: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8051: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
8052: END IF;
8053: RAISE FND_API.G_EXC_ERROR;
8054: END IF;

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

8047: FND_MESSAGE.Set_Token('ERRNO', 'IBE_ST_INVALID_OPERATION');
8048: FND_MESSAGE.Set_Token('REASON', 'size of line records does not match size of line quantities');
8049: FND_MSG_PUB.Add;
8050: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8051: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
8052: END IF;
8053: RAISE FND_API.G_EXC_ERROR;
8054: END IF;
8055:

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

8411: EXCEPTION
8412: WHEN FND_API.G_EXC_ERROR THEN
8413: ROLLBACK TO UPDATE_SUPPORT_LEVEL_AND_QTY;
8414: x_return_status := FND_API.G_RET_STS_ERROR;
8415: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
8416: p_count => x_msg_count,
8417: p_data => x_msg_data);
8418:
8419: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

8418:
8419: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8420: ROLLBACK TO UPDATE_SUPPORT_LEVEL_AND_QTY;
8421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8422: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
8423: p_count => x_msg_count,
8424: p_data => x_msg_data);
8425:
8426: WHEN OTHERS THEN

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

8425:
8426: WHEN OTHERS THEN
8427: ROLLBACK TO UPDATE_SUPPORT_LEVEL_AND_QTY;
8428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8429: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8430: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
8431: END IF;
8432: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
8433: p_count => x_msg_count,

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

8426: WHEN OTHERS THEN
8427: ROLLBACK TO UPDATE_SUPPORT_LEVEL_AND_QTY;
8428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8429: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8430: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
8431: END IF;
8432: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
8433: p_count => x_msg_count,
8434: p_data => x_msg_data);

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

8428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8429: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8430: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
8431: END IF;
8432: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
8433: p_count => x_msg_count,
8434: p_data => x_msg_data);
8435: END UPDATE_SUPPORT_AND_QUANTITY;
8436: