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 445: FND_Msg_Pub.initialize;

441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
442: END IF;
443: -- Initialize message list if p_init_msg_list is set to TRUE.
444: IF FND_API.To_Boolean(p_init_msg_list) THEN
445: FND_Msg_Pub.initialize;
446: END IF;
447: -- Initialize API return status to success
448: x_return_status := FND_API.G_RET_STS_SUCCESS;
449: -- API body

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

532: IF FND_API.To_Boolean(p_commit) THEN
533: COMMIT WORK;
534: END IF;
535: -- Standard call to get message count and if count is 1, get message info.
536: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
537: p_count => x_msg_count ,
538: p_data => x_msg_data);
539:
540: EXCEPTION

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

543: ibe_util.debug('Expected error in IBE_QUOTE_SAVE_PVT.header_agreements');
544: END IF;
545: ROLLBACK TO handle_header_agreements_pvt;
546: x_return_status := FND_API.G_RET_STS_ERROR;
547: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
548: p_count => x_msg_count ,
549: p_data => x_msg_data);
550: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
551: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

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

552: ibe_util.debug('Unexpected error in IBE_QUOTE_SAVE_PVT.header_agreements');
553: END IF;
554: ROLLBACK TO handle_header_agreements_pvt;
555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
556: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
557: p_count => x_msg_count ,
558: p_data => x_msg_data);
559: WHEN OTHERS THEN
560: ROLLBACK TO handle_header_agreements_pvt;

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

561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
562: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
563: ibe_util.debug('Unknown error in IBE_QUOTE_SAVE_PVT.header_agreements');
564: END IF;
565: IF FND_Msg_Pub.Check_Msg_Level( FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
566: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
567: L_API_NAME);
568: END IF;
569:

Line 566: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

562: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
563: ibe_util.debug('Unknown error in IBE_QUOTE_SAVE_PVT.header_agreements');
564: END IF;
565: IF FND_Msg_Pub.Check_Msg_Level( FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
566: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
567: L_API_NAME);
568: END IF;
569:
570: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

566: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
567: L_API_NAME);
568: END IF;
569:
570: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
571: p_count => x_msg_count ,
572: p_data => x_msg_data);
573:
574: end header_agreements;

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

632: -- update quote
633: /*A quote header_id is passed in during every update quote operation*/
634: ELSE
635: IF NOT FND_API.To_Boolean(p_auto_update_active_quote) THEN
636: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
637: FND_Message.Set_Name('IBE', 'IBE_SC_QUOTE_NEED_REFRESH');
638: FND_Msg_Pub.Add;
639: END IF;
640:

Line 638: FND_Msg_Pub.Add;

634: ELSE
635: IF NOT FND_API.To_Boolean(p_auto_update_active_quote) THEN
636: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
637: FND_Message.Set_Name('IBE', 'IBE_SC_QUOTE_NEED_REFRESH');
638: FND_Msg_Pub.Add;
639: END IF;
640:
641: RAISE FND_API.G_EXC_ERROR; -- need error message
642: END IF;

Line 1205: FND_Msg_Pub.initialize;

1201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1202: END IF;
1203: -- Initialize message list if p_init_msg_list is set to TRUE.
1204: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1205: FND_Msg_Pub.initialize;
1206: END IF;
1207: -- Initialize API return status to success
1208: x_return_status := FND_API.G_RET_STS_SUCCESS;
1209:

Line 1211: FND_Msg_Pub.initialize;

1207: -- Initialize API return status to success
1208: x_return_status := FND_API.G_RET_STS_SUCCESS;
1209:
1210: IF FND_API.To_Boolean(p_init_msg_list) THEN
1211: FND_Msg_Pub.initialize;
1212: END IF;
1213:
1214: -- API body
1215:

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

1258: COMMIT WORK;
1259: END IF;
1260:
1261: -- Standard call to get message count and if count is 1, get message info.
1262: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1263: p_count => x_msg_count ,
1264: p_data => x_msg_data);
1265: EXCEPTION
1266: WHEN FND_API.G_EXC_ERROR THEN

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

1268: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1269: IBE_UTIL.DEBUG('Expected error in IBE_QUOTE_SAVE_PVT.DeleteSharees');
1270: END IF;
1271: x_return_status := FND_API.G_RET_STS_ERROR;
1272: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1273: p_count => x_msg_count ,
1274: p_data => x_msg_data);
1275:
1276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1278: IBE_UTIL.DEBUG('Unexpected error in IBE_QUOTE_SAVE_PVT.DeleteSharees');
1279: END IF;
1280: ROLLBACK TO DELETESHAREES_pvt;
1281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1282: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1283: p_count => x_msg_count ,
1284: p_data => x_msg_data);
1285: WHEN OTHERS THEN
1286: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

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

1287: IBE_UTIL.DEBUG('Unknown error in IBE_QUOTE_SAVE_PVT.DeleteSharees');
1288: END IF;
1289: ROLLBACK TO DELETESHAREES_pvt;
1290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1291: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1292: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
1293: l_api_name);
1294: END IF;
1295: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 1292: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

1288: END IF;
1289: ROLLBACK TO DELETESHAREES_pvt;
1290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1291: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1292: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
1293: l_api_name);
1294: END IF;
1295: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1296: p_count => x_msg_count ,

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

1291: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1292: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
1293: l_api_name);
1294: END IF;
1295: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1296: p_count => x_msg_count ,
1297: p_data => x_msg_data);
1298: END DeleteSharees;
1299:

Line 1372: FND_Msg_Pub.initialize;

1368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1369: END IF;
1370: -- Initialize message list if p_init_msg_list is set to TRUE.
1371: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1372: FND_Msg_Pub.initialize;
1373: END IF;
1374: -- Initialize API return status to success
1375: x_return_status := FND_API.G_RET_STS_SUCCESS;
1376:

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

1431: --DBMS_OUTPUT.PUT_line('Quote not exists ');
1432: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1433: IBE_UTIL.DEBUG('Quote not exists ');
1434: END IF;
1435: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
1436: FND_Message.Set_Name('IBE', 'IBE_SC_NO_QUOTE_EXIST');
1437: FND_Msg_Pub.Add;
1438: END IF;
1439: RAISE FND_API.G_EXC_ERROR;

Line 1437: FND_Msg_Pub.Add;

1433: IBE_UTIL.DEBUG('Quote not exists ');
1434: END IF;
1435: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
1436: FND_Message.Set_Name('IBE', 'IBE_SC_NO_QUOTE_EXIST');
1437: FND_Msg_Pub.Add;
1438: END IF;
1439: RAISE FND_API.G_EXC_ERROR;
1440: ELSIF (l_quote_status = 'ORDERED') THEN
1441: --DBMS_OUTPUT.PUT_line('Quote ordered ');

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

1441: --DBMS_OUTPUT.PUT_line('Quote ordered ');
1442: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1443: IBE_UTIL.DEBUG('Quote ordered ');
1444: END IF;
1445: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
1446: FND_Message.Set_Name('IBE', 'IBE_SC_QUOTE_IS_ORDERED');
1447: FND_Msg_Pub.Add;
1448: END IF;
1449: RAISE FND_API.G_EXC_ERROR;

Line 1447: FND_Msg_Pub.Add;

1443: IBE_UTIL.DEBUG('Quote ordered ');
1444: END IF;
1445: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
1446: FND_Message.Set_Name('IBE', 'IBE_SC_QUOTE_IS_ORDERED');
1447: FND_Msg_Pub.Add;
1448: END IF;
1449: RAISE FND_API.G_EXC_ERROR;
1450: END IF;
1451: --Removing this validation because this is aleady being done in validate_user_update

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

1609: COMMIT WORK;
1610: END IF;
1611:
1612: -- Standard call to get message count and if count is 1, get message info.
1613: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1614: p_count => x_msg_count ,
1615: p_data => x_msg_data);
1616: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1617: IBE_Util.Debug('End IBE_Quote_Save_pvt.Delete()');

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

1624: END IF;
1625:
1626: ROLLBACK TO DELETE_pvt;
1627: x_return_status := FND_API.G_RET_STS_ERROR;
1628: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1629: p_count => x_msg_count ,
1630: p_data => x_msg_data);
1631: --IBE_Util.Disable_Debug;
1632: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1634: IBE_Util.Debug('Unexpected error: End IBE_Quote_Save_pvt.Delete()');
1635: END IF;
1636: ROLLBACK TO DELETE_pvt;
1637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1638: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1639: p_count => x_msg_count ,
1640: p_data => x_msg_data);
1641: -- IBE_Util.Disable_Debug;
1642: WHEN OTHERS THEN

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

1644: IBE_Util.Debug('Unknown error: End IBE_Quote_Save_pvt.Delete()');
1645: END IF;
1646: ROLLBACK TO DELETE_pvt;
1647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1648: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1649: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
1650: l_api_name);
1651: END IF;
1652: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 1649: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

1645: END IF;
1646: ROLLBACK TO DELETE_pvt;
1647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1648: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1649: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
1650: l_api_name);
1651: END IF;
1652: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1653: p_count => x_msg_count ,

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

1648: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1649: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
1650: l_api_name);
1651: END IF;
1652: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1653: p_count => x_msg_count ,
1654: p_data => x_msg_data);
1655: --IBE_Util.Disable_Debug;
1656: END DELETE;

Line 1703: FND_Msg_Pub.initialize;

1699: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1700: END IF;
1701: -- Initialize message list if p_init_msg_list is set to TRUE.
1702: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1703: FND_Msg_Pub.initialize;
1704: END IF;
1705: -- Initialize API return status to success
1706: x_return_status := FND_API.G_RET_STS_SUCCESS;
1707:

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

1773: END IF;
1774:
1775: -- Standard call to get message count and if count is 1, get message info.
1776:
1777: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1778: p_count => x_msg_count ,
1779: p_data => x_msg_data);
1780:
1781: EXCEPTION

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

1784: IBE_Util.Debug('Expected error: IBE_Quote_Save_pvt.DeleteAllLines()');
1785: END IF;
1786: ROLLBACK TO DELETEALLLINES_pvt;
1787: x_return_status := FND_API.G_RET_STS_ERROR;
1788: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1789: p_count => x_msg_count ,
1790: p_data => x_msg_data);
1791:
1792: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1795: END IF;
1796:
1797: ROLLBACK TO DELETEALLLINES_pvt;
1798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1799: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1800: p_count => x_msg_count,
1801: p_data => x_msg_data);
1802: WHEN OTHERS THEN
1803: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

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

1806:
1807: ROLLBACK TO DELETEALLLINES_pvt;
1808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1809:
1810: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1811: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
1812: l_api_name);
1813: END IF;
1814: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 1811: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

1807: ROLLBACK TO DELETEALLLINES_pvt;
1808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1809:
1810: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1811: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
1812: l_api_name);
1813: END IF;
1814: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1815: p_count => x_msg_count ,

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

1810: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1811: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
1812: l_api_name);
1813: END IF;
1814: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1815: p_count => x_msg_count ,
1816: p_data => x_msg_data);
1817: END DeleteAllLines;
1818:

Line 2037: FND_Msg_Pub.initialize;

2033: END IF;
2034:
2035: -- Initialize message list if p_init_msg_list is set to TRUE.
2036: IF FND_API.To_Boolean(p_init_msg_list) THEN
2037: FND_Msg_Pub.initialize;
2038: END IF;
2039:
2040: -- Initialize API return status to success
2041: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2732: COMMIT WORK;
2733: END IF;
2734:
2735: -- Standard call to get message count and if count is 1, get message info.
2736: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2737: p_count => x_msg_count ,
2738: p_data => x_msg_data);
2739:
2740: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

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

2749: END IF;
2750:
2751: ROLLBACK TO AddItemsToCartorig_pvt;
2752: x_return_status := FND_API.G_RET_STS_ERROR;
2753: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2754: p_count => x_msg_count ,
2755: p_data => x_msg_data);
2756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2757: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

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

2759: END IF;
2760:
2761: ROLLBACK TO AddItemsToCartorig_pvt;
2762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2763: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2764: p_count => x_msg_count ,
2765: p_data => x_msg_data);
2766: WHEN OTHERS THEN
2767: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

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

2769: END IF;
2770:
2771: ROLLBACK TO AddItemsToCartorig_pvt;
2772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2773: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2774: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
2775: l_api_name);
2776: END IF;
2777: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 2774: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

2770:
2771: ROLLBACK TO AddItemsToCartorig_pvt;
2772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2773: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2774: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
2775: l_api_name);
2776: END IF;
2777: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2778: p_count => x_msg_count ,

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

2773: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2774: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
2775: l_api_name);
2776: END IF;
2777: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2778: p_count => x_msg_count ,
2779: p_data => x_msg_data);
2780:
2781: END AddItemsToCart_orig;

Line 2979: FND_Msg_Pub.initialize;

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

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

3140: IF (l_config_header_id is NULL) THEN
3141: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3142: IBE_Util.Debug('Error in CZ_CF_API.Validate:Printing the terminate string: '||lx_xml_from_validate);
3143: END IF;
3144: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
3145: FND_Message.Set_Name('IBE','IBE_DSP_GENERIC_ERROR_TXT');
3146: FND_Message.Set_Token('IBE_DSP_GENERIC_ERROR_TXT',lx_xml_from_validate);
3147: FND_Msg_Pub.Add;
3148: END IF;

Line 3147: FND_Msg_Pub.Add;

3143: END IF;
3144: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
3145: FND_Message.Set_Name('IBE','IBE_DSP_GENERIC_ERROR_TXT');
3146: FND_Message.Set_Token('IBE_DSP_GENERIC_ERROR_TXT',lx_xml_from_validate);
3147: FND_Msg_Pub.Add;
3148: END IF;
3149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3150: END IF;
3151:

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

3212: END IF;
3213:
3214: ROLLBACK TO ADDITEMSTOCART_pvt;
3215: x_return_status := FND_API.G_RET_STS_ERROR;
3216: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
3217: p_count => x_msg_count ,
3218: p_data => x_msg_data);
3219:
3220: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

3222: IBE_Util.Debug('Unexpected error: IBE_Quote_Save_pvt.AddItemsToCart() (new one)');
3223: END IF;
3224: ROLLBACK TO ADDITEMSTOCART_pvt;
3225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3226: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
3227: p_count => x_msg_count ,
3228: p_data => x_msg_data);
3229:
3230: WHEN OTHERS THEN

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

3232: IBE_Util.Debug('Unknown error: IBE_Quote_Save_pvt.AddItemsToCart) (new one)');
3233: END IF;
3234: ROLLBACK TO ADDITEMSTOCART_pvt;
3235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3236: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
3237: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
3238: l_api_name);
3239: END IF;
3240: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 3237: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

3233: END IF;
3234: ROLLBACK TO ADDITEMSTOCART_pvt;
3235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3236: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
3237: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
3238: l_api_name);
3239: END IF;
3240: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
3241: p_count => x_msg_count ,

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

3236: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
3237: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
3238: l_api_name);
3239: END IF;
3240: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
3241: p_count => x_msg_count ,
3242: p_data => x_msg_data);
3243: END AddItemsToCart;
3244:

Line 3467: FND_Msg_Pub.initialize;

3463: END IF;
3464:
3465: -- Initialize message list if p_init_msg_list is set to TRUE.
3466: IF FND_API.To_Boolean(p_init_msg_list) THEN
3467: FND_Msg_Pub.initialize;
3468: END IF;
3469:
3470: -- Initialize API return status to success
3471: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3529: COMMIT WORK;
3530: END IF;
3531:
3532: -- Standard call to get message count and if count is 1, get message info.
3533: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
3534: p_count => x_msg_count ,
3535: p_data => x_msg_data);
3536:
3537: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

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

3544: END IF;
3545:
3546: ROLLBACK TO Get_quote_exp_date_pvt;
3547: x_return_status := FND_API.G_RET_STS_ERROR;
3548: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
3549: p_count => x_msg_count ,
3550: p_data => x_msg_data);
3551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3552: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

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

3554: END IF;
3555:
3556: ROLLBACK TO Get_quote_exp_date_pvt;
3557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3558: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
3559: p_count => x_msg_count ,
3560: p_data => x_msg_data);
3561: WHEN OTHERS THEN
3562: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

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

3564: END IF;
3565:
3566: ROLLBACK TO Get_quote_exp_date_pvt;
3567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3568: IF FND_Msg_Pub.Check_Msg_Level( FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
3569: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
3570: L_API_NAME);
3571: END IF;
3572:

Line 3569: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

3565:
3566: ROLLBACK TO Get_quote_exp_date_pvt;
3567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3568: IF FND_Msg_Pub.Check_Msg_Level( FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
3569: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
3570: L_API_NAME);
3571: END IF;
3572:
3573: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

3569: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
3570: L_API_NAME);
3571: END IF;
3572:
3573: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
3574: p_count => x_msg_count ,
3575: p_data => x_msg_data);
3576: End Get_Quote_expiration_date;
3577:

Line 3688: FND_Msg_Pub.initialize;

3684: END IF;
3685:
3686: -- Initialize message list if p_init_msg_list is set to TRUE.
3687: IF FND_API.To_Boolean(p_init_msg_list) THEN
3688: FND_Msg_Pub.initialize;
3689: END IF;
3690: -- Initialize API return status to success
3691: x_return_status := FND_API.G_RET_STS_SUCCESS;
3692:

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

4055: COMMIT WORK;
4056: END IF;
4057:
4058: -- Standard call to get message count and if count is 1, get message info.
4059: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
4060: p_count => lx_msg_count ,
4061: p_data => lx_msg_data);
4062:
4063: EXCEPTION

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

4068:
4069: ROLLBACK TO Req_for_sales_asst_pvt;
4070: x_return_status := FND_API.G_RET_STS_ERROR;
4071: Set_Last_Update_Date(p_quote_header_id, x_last_update_date);
4072: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
4073: p_count => lx_msg_count ,
4074: p_data => lx_msg_data);
4075: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4076: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

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

4078: END IF;
4079:
4080: ROLLBACK TO Req_for_sales_asst_pvt;
4081: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4082: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
4083: p_count => lx_msg_count ,
4084: p_data => lx_msg_data);
4085: WHEN OTHERS THEN
4086: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

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

4089:
4090: ROLLBACK TO Req_for_sales_asst_pvt;
4091: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4092: Set_Last_Update_Date(p_quote_header_id, x_last_update_date);
4093: IF FND_Msg_Pub.Check_Msg_Level( FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
4094: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
4095: L_API_NAME);
4096: END IF;
4097:

Line 4094: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

4090: ROLLBACK TO Req_for_sales_asst_pvt;
4091: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4092: Set_Last_Update_Date(p_quote_header_id, x_last_update_date);
4093: IF FND_Msg_Pub.Check_Msg_Level( FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
4094: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
4095: L_API_NAME);
4096: END IF;
4097:
4098: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

4094: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
4095: L_API_NAME);
4096: END IF;
4097:
4098: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
4099: p_count => lx_msg_count ,
4100: p_data => lx_msg_data);
4101:
4102: End request_for_sales_assistance;

Line 4432: FND_Msg_Pub.initialize;

4428: END IF;
4429:
4430: -- Initialize message list if p_init_msg_list is set to TRUE.
4431: IF FND_API.To_Boolean( p_init_msg_list ) THEN
4432: FND_Msg_Pub.initialize;
4433: END IF;
4434:
4435: -- Initialize API return status to success
4436: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

4495: p_Qte_Header_Rec.party_id,
4496: p_Qte_Header_Rec.cust_account_id);
4497: --Raise an error f the above validation failed
4498: IF(l_is_quote_usable = FND_API.G_FALSE) THEN
4499: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4500: FND_Message.Set_Name('IBE', 'IBE_SC_CART_EXPIRED');
4501: FND_Msg_Pub.Add;
4502: END IF;
4503: RAISE FND_API.G_EXC_ERROR;

Line 4501: FND_Msg_Pub.Add;

4497: --Raise an error f the above validation failed
4498: IF(l_is_quote_usable = FND_API.G_FALSE) THEN
4499: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4500: FND_Message.Set_Name('IBE', 'IBE_SC_CART_EXPIRED');
4501: FND_Msg_Pub.Add;
4502: END IF;
4503: RAISE FND_API.G_EXC_ERROR;
4504: END IF;
4505: Default_Header_Record( p_qte_header_rec => p_qte_header_rec

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

4574: l_privilege_type_code := IBE_Quote_Misc_pvt.GetShareeprivilege(l_qte_header_rec.quote_header_id
4575: ,p_sharee_Number);
4576: IF ((l_privilege_type_code <> 'A')
4577: and (l_privilege_type_code <> 'F' )) THEN
4578: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4579: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_PRIVILEGE');
4580: FND_Msg_Pub.Add;
4581: END IF;
4582: RAISE FND_API.G_EXC_ERROR; -- need error message

Line 4580: FND_Msg_Pub.Add;

4576: IF ((l_privilege_type_code <> 'A')
4577: and (l_privilege_type_code <> 'F' )) THEN
4578: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4579: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_PRIVILEGE');
4580: FND_Msg_Pub.Add;
4581: END IF;
4582: RAISE FND_API.G_EXC_ERROR; -- need error message
4583: END IF;
4584:

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

4583: END IF;
4584:
4585: IF ( l_privilege_type_code <> 'A'
4586: and FND_API.To_Boolean(p_changeowner) )THEN
4587: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4588: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_PRIVILEGE');
4589: FND_Msg_Pub.Add;
4590: END IF;
4591: RAISE FND_API.G_EXC_ERROR; -- need error message

Line 4589: FND_Msg_Pub.Add;

4585: IF ( l_privilege_type_code <> 'A'
4586: and FND_API.To_Boolean(p_changeowner) )THEN
4587: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4588: FND_Message.Set_Name('IBE', 'IBE_SC_ERR_PRIVILEGE');
4589: FND_Msg_Pub.Add;
4590: END IF;
4591: RAISE FND_API.G_EXC_ERROR; -- need error message
4592: END IF;
4593: END IF; -- p_sharee_number is not null

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

4774: END IF;
4775: END IF;
4776: EXCEPTION
4777: When OTHERS THEN
4778: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4779: FND_MESSAGE.set_name('IBE', 'IBE_UPDATE_MSITE_HDR_ERR');
4780: FND_MSG_PUB.add;
4781: END IF;
4782: RAISE FND_API.G_EXC_ERROR;

Line 4780: FND_MSG_PUB.add;

4776: EXCEPTION
4777: When OTHERS THEN
4778: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4779: FND_MESSAGE.set_name('IBE', 'IBE_UPDATE_MSITE_HDR_ERR');
4780: FND_MSG_PUB.add;
4781: END IF;
4782: RAISE FND_API.G_EXC_ERROR;
4783: END;
4784:

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

4790: IBE_Quote_Misc_pvt.Get_Active_Quote_ID
4791: (p_party_id => x_qte_header_rec.party_id
4792: ,p_cust_account_id => x_qte_header_rec.cust_account_id
4793: ,p_only_max => FALSE) then
4794: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4795: FND_Message.Set_Name('IBE', 'IBE_SC_QUOTE_NEED_REFRESH');
4796: FND_Msg_Pub.Add;
4797: END IF;
4798: RAISE FND_API.G_EXC_ERROR; -- need error message

Line 4796: FND_Msg_Pub.Add;

4792: ,p_cust_account_id => x_qte_header_rec.cust_account_id
4793: ,p_only_max => FALSE) then
4794: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4795: FND_Message.Set_Name('IBE', 'IBE_SC_QUOTE_NEED_REFRESH');
4796: FND_Msg_Pub.Add;
4797: END IF;
4798: RAISE FND_API.G_EXC_ERROR; -- need error message
4799: END IF;
4800: END IF;*/

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

4858: l_hd_payment_tbl(I).last_update_date :=
4859: IBE_Quote_Misc_pvt.getQuoteLastUpdateDate(l_qte_header_rec.quote_header_id); -- Bug# 1955991
4860: */
4861: /* Bug#1955991
4862: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4863: FND_Message.Set_Name('IBE', 'IBE_QUOTE_HDR_PMT_RCRD_EXISTS');
4864: FND_Msg_Pub.Add;
4865: END IF;
4866: RAISE FND_API.G_EXC_ERROR;

Line 4864: FND_Msg_Pub.Add;

4860: */
4861: /* Bug#1955991
4862: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4863: FND_Message.Set_Name('IBE', 'IBE_QUOTE_HDR_PMT_RCRD_EXISTS');
4864: FND_Msg_Pub.Add;
4865: END IF;
4866: RAISE FND_API.G_EXC_ERROR;
4867: */
4868: END IF;

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

4869: END IF;
4870: END LOOP;
4871: /* Bug#1955991
4872: IF l_count > 1 THEN -- Trying to create more than one header payment
4873: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4874: FND_Message.Set_Name('IBE', 'IBE_QUOTE_HDR_PMT_RCRD_EXISTS');
4875: FND_Msg_Pub.Add;
4876: END IF;
4877: RAISE FND_API.G_EXC_ERROR;

Line 4875: FND_Msg_Pub.Add;

4871: /* Bug#1955991
4872: IF l_count > 1 THEN -- Trying to create more than one header payment
4873: IF FND_Msg_Pub.Check_Msg_Level (FND_Msg_Pub.G_MSG_LVL_ERROR) THEN
4874: FND_Message.Set_Name('IBE', 'IBE_QUOTE_HDR_PMT_RCRD_EXISTS');
4875: FND_Msg_Pub.Add;
4876: END IF;
4877: RAISE FND_API.G_EXC_ERROR;
4878: END IF;
4879: */

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

5117: COMMIT WORK;
5118: END IF;
5119:
5120: -- Standard call to get message count and if count is 1, get message info.
5121: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
5122: p_count => x_msg_count ,
5123: p_data => x_msg_data);
5124: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5125: IBE_Util.Debug('Normal End IBE_Quote_Save_pvt.Save()');

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

5132: END IF;
5133: ROLLBACK TO SAVE_pvt;
5134: x_return_status := FND_API.G_RET_STS_ERROR;
5135: Set_Last_Update_Date(l_qte_header_rec.quote_header_id, x_last_update_date);
5136: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
5137: p_count => x_msg_count ,
5138: p_data => x_msg_data);
5139: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5140: IBE_Util.Debug('Unexpected error IBE_Quote_Save_pvt.Save()');

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

5142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5143: ROLLBACK TO SAVE_pvt;
5144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5145: Set_Last_Update_Date(l_qte_header_rec.quote_header_id, x_last_update_date);
5146: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
5147: p_count => x_msg_count ,
5148: p_data => x_msg_data);
5149: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5150: IBE_Util.Debug('Unknown exception End IBE_Quote_Save_pvt.Save()');

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

5152: WHEN OTHERS THEN
5153: ROLLBACK TO SAVE_pvt;
5154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5155: Set_Last_Update_Date(l_qte_header_rec.quote_header_id, x_last_update_date);
5156: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
5157: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
5158: l_api_name);
5159: END IF;
5160: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 5157: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

5153: ROLLBACK TO SAVE_pvt;
5154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5155: Set_Last_Update_Date(l_qte_header_rec.quote_header_id, x_last_update_date);
5156: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
5157: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
5158: l_api_name);
5159: END IF;
5160: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
5161: p_count => x_msg_count ,

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

5156: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
5157: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
5158: l_api_name);
5159: END IF;
5160: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
5161: p_count => x_msg_count ,
5162: p_data => x_msg_data);
5163: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5164: IBE_Util.Debug('End IBE_Quote_Save_pvt.Save()');

Line 5277: FND_Msg_Pub.initialize;

5273:
5274: -- Initialize message list if p_init_msg_list is set to TRUE.
5275:
5276: IF FND_API.To_Boolean( p_init_msg_list ) THEN
5277: FND_Msg_Pub.initialize;
5278: END IF;
5279: -- Initialize API return status to success
5280: x_return_status := FND_API.G_RET_STS_SUCCESS;
5281:

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

5425: COMMIT WORK;
5426: END IF;
5427:
5428: -- Standard call to get message count and if count is 1, get message info.
5429: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
5430: p_count => x_msg_count ,
5431: p_data => x_msg_data);
5432: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5433: IBE_Util.Debug('End IBE_Quote_Save_pvt.UpdateQuoteForSharee()');

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

5436: EXCEPTION
5437: WHEN FND_API.G_EXC_ERROR THEN
5438: ROLLBACK TO UpdateQuoteForSharee_pvt;
5439: x_return_status := FND_API.G_RET_STS_ERROR;
5440: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
5441: p_count => x_msg_count ,
5442: p_data => x_msg_data);
5443: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5444: IBE_Util.Debug('End IBE_Quote_Save_pvt.UpdateQuoteForSharee()');

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

5446: -- IBE_Util.Disable_Debug;
5447: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5448: ROLLBACK TO UpdateQuoteForSharee_pvt;
5449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5450: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
5451: p_count => x_msg_count ,
5452: p_data => x_msg_data);
5453: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5454: IBE_Util.Debug('End IBE_Quote_Save_pvt.UpdateQuoteForSharee()');

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

5457: WHEN OTHERS THEN
5458: ROLLBACK TO UpdateQuoteForSharee_pvt;
5459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5460:
5461: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
5462: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
5463: l_api_name);
5464: END IF;
5465:

Line 5462: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

5458: ROLLBACK TO UpdateQuoteForSharee_pvt;
5459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5460:
5461: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
5462: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
5463: l_api_name);
5464: END IF;
5465:
5466: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

5462: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
5463: l_api_name);
5464: END IF;
5465:
5466: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
5467: p_count => x_msg_count ,
5468: p_data => x_msg_data);
5469: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5470: IBE_Util.Debug('End IBE_Quote_Save_pvt.UpdateQuoteForSharee()');

Line 5557: FND_Msg_Pub.initialize;

5553: END IF;
5554:
5555: -- Initialize message list if p_init_msg_list is set to TRUE.
5556: IF FND_API.To_Boolean(p_init_msg_list) THEN
5557: FND_Msg_Pub.initialize;
5558: END IF;
5559:
5560: -- Initialize API return status to success
5561: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

5890: COMMIT WORK;
5891: END IF;
5892:
5893: -- Standard call to get message count and if count is 1, get message info.
5894: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
5895: p_count => x_msg_count ,
5896: p_data => x_msg_data);
5897: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5898: IBE_Util.Debug('End IBE_Quote_Save_pvt.getHdrDefaultValues()');

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

5902: EXCEPTION
5903: WHEN FND_API.G_EXC_ERROR THEN
5904: ROLLBACK TO getHdrDefaultValues_PVT;
5905: x_return_status := FND_API.G_RET_STS_ERROR;
5906: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
5907: p_count => x_msg_count ,
5908: p_data => x_msg_data);
5909: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5910: ROLLBACK TO getHdrDefaultValues_PVT;

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

5908: p_data => x_msg_data);
5909: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5910: ROLLBACK TO getHdrDefaultValues_PVT;
5911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5912: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
5913: p_count => x_msg_count ,
5914: p_data => x_msg_data);
5915: WHEN OTHERS THEN
5916: ROLLBACK TO getHdrDefaultValues_PVT;

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

5914: p_data => x_msg_data);
5915: WHEN OTHERS THEN
5916: ROLLBACK TO getHdrDefaultValues_PVT;
5917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5918: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
5919: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
5920: l_api_name);
5921: END IF;
5922: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 5919: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

5915: WHEN OTHERS THEN
5916: ROLLBACK TO getHdrDefaultValues_PVT;
5917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5918: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
5919: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
5920: l_api_name);
5921: END IF;
5922: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
5923: p_count => x_msg_count ,

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

5918: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
5919: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
5920: l_api_name);
5921: END IF;
5922: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
5923: p_count => x_msg_count ,
5924: p_data => x_msg_data);
5925: END getHdrDefaultValues;
5926:

Line 6006: FND_Msg_Pub.initialize;

6002: END IF;
6003:
6004: -- Initialize message list if p_init_msg_list is set to TRUE.
6005: IF FND_API.To_Boolean(p_init_msg_list) THEN
6006: FND_Msg_Pub.initialize;
6007: END IF;
6008:
6009: -- Initialize API return status to success
6010: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

6206: COMMIT WORK;
6207: END IF;
6208:
6209: -- Standard call to get message count and if count is 1, get message info.
6210: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6211: p_count => x_msg_count ,
6212: p_data => x_msg_data);
6213: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
6214: IBE_Util.Debug('End IBE_Quote_Save_pvt.getHdrDefaultAddress()');

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

6218: EXCEPTION
6219: WHEN FND_API.G_EXC_ERROR THEN
6220: ROLLBACK TO getHdrDefaultAddress_pvt;
6221: x_return_status := FND_API.G_RET_STS_ERROR;
6222: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6223: p_count => x_msg_count ,
6224: p_data => x_msg_data);
6225: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6226: ROLLBACK TO getHdrDefaultAddress_pvt;

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

6224: p_data => x_msg_data);
6225: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6226: ROLLBACK TO getHdrDefaultAddress_pvt;
6227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6228: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6229: p_count => x_msg_count ,
6230: p_data => x_msg_data);
6231: WHEN OTHERS THEN
6232: ROLLBACK TO getHdrDefaultAddress_pvt;

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

6230: p_data => x_msg_data);
6231: WHEN OTHERS THEN
6232: ROLLBACK TO getHdrDefaultAddress_pvt;
6233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6234: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
6235: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
6236: l_api_name);
6237: END IF;
6238: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 6235: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

6231: WHEN OTHERS THEN
6232: ROLLBACK TO getHdrDefaultAddress_pvt;
6233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6234: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
6235: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
6236: l_api_name);
6237: END IF;
6238: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6239: p_count => x_msg_count ,

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

6234: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
6235: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
6236: l_api_name);
6237: END IF;
6238: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6239: p_count => x_msg_count ,
6240: p_data => x_msg_data);
6241:
6242: end getHdrDefaultAddress;

Line 6310: FND_Msg_Pub.initialize;

6306: END IF;
6307:
6308: -- Initialize message list if p_init_msg_list is set to TRUE.
6309: IF FND_API.To_Boolean(p_init_msg_list) THEN
6310: FND_Msg_Pub.initialize;
6311: END IF;
6312:
6313: -- Initialize API return status to success
6314: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

6448: COMMIT WORK;
6449: END IF;
6450:
6451: -- Standard call to get message count and if count is 1, get message info.
6452: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6453: p_count => x_msg_count ,
6454: p_data => x_msg_data);
6455: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
6456: IBE_Util.Debug('End IBE_Quote_Save_pvt.getHdrDefaultShipMethod()');

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

6461: EXCEPTION
6462: WHEN FND_API.G_EXC_ERROR THEN
6463: ROLLBACK TO getHdrDefaultShipMethod_pvt;
6464: x_return_status := FND_API.G_RET_STS_ERROR;
6465: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6466: p_count => x_msg_count ,
6467: p_data => x_msg_data);
6468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6469: ROLLBACK TO getHdrDefaultShipMethod_pvt;

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

6467: p_data => x_msg_data);
6468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6469: ROLLBACK TO getHdrDefaultShipMethod_pvt;
6470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6471: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6472: p_count => x_msg_count ,
6473: p_data => x_msg_data);
6474: WHEN OTHERS THEN
6475: ROLLBACK TO getHdrDefaultShipMethod_pvt;

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

6473: p_data => x_msg_data);
6474: WHEN OTHERS THEN
6475: ROLLBACK TO getHdrDefaultShipMethod_pvt;
6476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6477: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
6478: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
6479: l_api_name);
6480: END IF;
6481: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 6478: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

6474: WHEN OTHERS THEN
6475: ROLLBACK TO getHdrDefaultShipMethod_pvt;
6476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6477: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
6478: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
6479: l_api_name);
6480: END IF;
6481: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6482: p_count => x_msg_count ,

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

6477: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
6478: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
6479: l_api_name);
6480: END IF;
6481: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6482: p_count => x_msg_count ,
6483: p_data => x_msg_data);
6484: end getHdrDefaultShipMethod;
6485:

Line 6565: FND_Msg_Pub.initialize;

6561: END IF;
6562:
6563: -- Initialize message list if p_init_msg_list is set to TRUE.
6564: IF FND_API.To_Boolean(p_init_msg_list) THEN
6565: FND_Msg_Pub.initialize;
6566: END IF;
6567:
6568: -- Initialize API return status to success
6569: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

6774: COMMIT WORK;
6775: END IF;
6776:
6777: -- Standard call to get message count and if count is 1, get message info.
6778: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6779: p_count => x_msg_count ,
6780: p_data => x_msg_data);
6781: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
6782: IBE_Util.Debug('End IBE_Quote_Save_pvt.getHdrDefaultPaymentMethod()');

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

6786: EXCEPTION
6787: WHEN FND_API.G_EXC_ERROR THEN
6788: ROLLBACK TO getHdrDefPmtMethod_pvt;
6789: x_return_status := FND_API.G_RET_STS_ERROR;
6790: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6791: p_count => x_msg_count ,
6792: p_data => x_msg_data);
6793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6794: ROLLBACK TO getHdrDefPmtMethod_pvt;

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

6792: p_data => x_msg_data);
6793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6794: ROLLBACK TO getHdrDefPmtMethod_pvt;
6795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6796: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6797: p_count => x_msg_count ,
6798: p_data => x_msg_data);
6799: WHEN OTHERS THEN
6800: ROLLBACK TO getHdrDefPmtMethod_pvt;

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

6798: p_data => x_msg_data);
6799: WHEN OTHERS THEN
6800: ROLLBACK TO getHdrDefPmtMethod_pvt;
6801: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6802: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
6803: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
6804: l_api_name);
6805: END IF;
6806: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 6803: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

6799: WHEN OTHERS THEN
6800: ROLLBACK TO getHdrDefPmtMethod_pvt;
6801: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6802: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
6803: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
6804: l_api_name);
6805: END IF;
6806: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6807: p_count => x_msg_count ,

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

6802: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
6803: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
6804: l_api_name);
6805: END IF;
6806: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6807: p_count => x_msg_count ,
6808: p_data => x_msg_data);
6809: end getHdrDefaultPaymentMethod;
6810:

Line 6857: FND_Msg_Pub.initialize;

6853: END IF;
6854:
6855: -- Initialize message list if p_init_msg_list is set to TRUE.
6856: IF FND_API.To_Boolean(p_init_msg_list) THEN
6857: FND_Msg_Pub.initialize;
6858: END IF;
6859:
6860: -- Initialize API return status to success
6861: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

6895: px_hd_Tax_Detail_Tbl(1).tax_exempt_flag := 'S';
6896: end if;
6897:
6898: -- Standard call to get message count and if count is 1, get message info.
6899: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6900: p_count => x_msg_count ,
6901: p_data => x_msg_data);
6902: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
6903: IBE_Util.Debug('End IBE_Quote_Save_pvt.getHdrDefaultTaxExemption()');

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

6907: EXCEPTION
6908: WHEN FND_API.G_EXC_ERROR THEN
6909: ROLLBACK TO getHdrDefTaxExmpt_pvt;
6910: x_return_status := FND_API.G_RET_STS_ERROR;
6911: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6912: p_count => x_msg_count ,
6913: p_data => x_msg_data);
6914: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6915: ROLLBACK TO getHdrDefTaxExmpt_pvt;

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

6913: p_data => x_msg_data);
6914: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6915: ROLLBACK TO getHdrDefTaxExmpt_pvt;
6916: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6917: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6918: p_count => x_msg_count ,
6919: p_data => x_msg_data);
6920: WHEN OTHERS THEN
6921: ROLLBACK TO getHdrDefTaxExmpt_pvt;

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

6919: p_data => x_msg_data);
6920: WHEN OTHERS THEN
6921: ROLLBACK TO getHdrDefTaxExmpt_pvt;
6922: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6923: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
6924: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
6925: l_api_name);
6926: END IF;
6927: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 6924: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

6920: WHEN OTHERS THEN
6921: ROLLBACK TO getHdrDefTaxExmpt_pvt;
6922: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6923: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
6924: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
6925: l_api_name);
6926: END IF;
6927: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6928: p_count => x_msg_count ,

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

6923: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
6924: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
6925: l_api_name);
6926: END IF;
6927: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6928: p_count => x_msg_count ,
6929: p_data => x_msg_data);
6930:
6931: end getHdrDefaultTaxExemption;

Line 6980: FND_Msg_Pub.initialize;

6976: END IF;
6977:
6978: -- Initialize message list if p_init_msg_list is set to TRUE.
6979: IF FND_API.To_Boolean(p_init_msg_list) THEN
6980: FND_Msg_Pub.initialize;
6981: END IF;
6982:
6983: -- Initialize API return status to success
6984: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

7042: COMMIT WORK;
7043: END IF;
7044:
7045: -- Standard call to get message count and if count is 1, get message info.
7046: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
7047: p_count => x_msg_count ,
7048: p_data => x_msg_data);
7049: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
7050: IBE_Util.Debug('End IBE_Quote_Save_pvt.getHdrDefaultEndCustomer()');

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

7054: EXCEPTION
7055: WHEN FND_API.G_EXC_ERROR THEN
7056: ROLLBACK TO getHdrDefaultEndCustomer_pvt;
7057: x_return_status := FND_API.G_RET_STS_ERROR;
7058: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
7059: p_count => x_msg_count ,
7060: p_data => x_msg_data);
7061: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7062: ROLLBACK TO getHdrDefaultEndCustomer_pvt;

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

7060: p_data => x_msg_data);
7061: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7062: ROLLBACK TO getHdrDefaultEndCustomer_pvt;
7063: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7064: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
7065: p_count => x_msg_count ,
7066: p_data => x_msg_data);
7067: WHEN OTHERS THEN
7068: ROLLBACK TO getHdrDefaultEndCustomer_pvt;

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

7066: p_data => x_msg_data);
7067: WHEN OTHERS THEN
7068: ROLLBACK TO getHdrDefaultEndCustomer_pvt;
7069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7070: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
7071: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
7072: l_api_name);
7073: END IF;
7074: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 7071: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,

7067: WHEN OTHERS THEN
7068: ROLLBACK TO getHdrDefaultEndCustomer_pvt;
7069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7070: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
7071: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
7072: l_api_name);
7073: END IF;
7074: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
7075: p_count => x_msg_count ,

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

7070: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
7071: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
7072: l_api_name);
7073: END IF;
7074: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
7075: p_count => x_msg_count ,
7076: p_data => x_msg_data);
7077:
7078: end getHdrDefaultEndCustomer;

Line 7126: FND_Msg_Pub.initialize;

7122: END IF;
7123:
7124: -- Initialize message list if p_init_msg_list is set to TRUE.
7125: IF FND_API.To_Boolean(p_Init_Msg_List) THEN
7126: FND_Msg_Pub.initialize;
7127: END IF;
7128: -- Initialize API return status to success
7129: x_return_status := FND_API.G_RET_STS_SUCCESS;
7130:

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

7247:
7248:
7249:
7250: -- Standard call to get message count and if count is 1, get message info.
7251: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
7252: p_count => x_msg_count ,
7253: p_data => x_msg_data);
7254: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
7255: IBE_Util.Debug('End IBE_Quote_Save_pvt.getHdrDefaultTaxExemption()');

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

7261:
7262: WHEN FND_API.G_EXC_ERROR THEN
7263: ROLLBACK TO CREATECONTRACTFORQUOTE_pvt;
7264: x_return_status := FND_API.G_RET_STS_ERROR;
7265: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
7266: p_count => x_msg_count,
7267: p_data => x_msg_data);
7268:
7269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

7268:
7269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7270: ROLLBACK TO CREATECONTRACTFORQUOTE_pvt;
7271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7272: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
7273: p_count => x_msg_count,
7274: p_data => x_msg_data);
7275:
7276: WHEN OTHERS THEN

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

7276: WHEN OTHERS THEN
7277: ROLLBACK TO CREATECONTRACTFORQUOTE_pvt;
7278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7279:
7280: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7281: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
7282: l_api_name);
7283: END IF;
7284:

Line 7281: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

7277: ROLLBACK TO CREATECONTRACTFORQUOTE_pvt;
7278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7279:
7280: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7281: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
7282: l_api_name);
7283: END IF;
7284:
7285: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

7281: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
7282: l_api_name);
7283: END IF;
7284:
7285: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
7286: p_count => x_msg_count,
7287: p_data => x_msg_data);
7288:
7289: END CREATE_CONTRACT_FOR_QUOTE;

Line 7400: FND_Msg_Pub.initialize;

7396: END IF;
7397:
7398: -- Initialize message list if p_init_msg_list is set to TRUE.
7399: IF FND_API.To_Boolean(p_init_msg_list) THEN
7400: FND_Msg_Pub.initialize;
7401: END IF;
7402: -- Initialize API return status to success
7403: x_return_status := FND_API.G_RET_STS_SUCCESS;
7404:

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

7611: END IF;
7612: x_quote_header_id := lx_quote_header_id;
7613:
7614: -- Standard call to get message count and if count is 1, get message info.
7615: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
7616: p_count => x_msg_count ,
7617: p_data => x_msg_data);
7618: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
7619: IBE_Util.Debug('End IBE_Quote_Save_pvt.Duplicate_cart');

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

7625:
7626: WHEN FND_API.G_EXC_ERROR THEN
7627: ROLLBACK TO Duplicate_Cart;
7628: x_return_status := FND_API.G_RET_STS_ERROR;
7629: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
7630: p_count => x_msg_count,
7631: p_data => x_msg_data);
7632:
7633: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

7632:
7633: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7634: ROLLBACK TO Duplicate_Cart;
7635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7636: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
7637: p_count => x_msg_count,
7638: p_data => x_msg_data);
7639:
7640: WHEN OTHERS THEN

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

7640: WHEN OTHERS THEN
7641: ROLLBACK TO Duplicate_Cart;
7642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7643:
7644: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7645: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
7646: l_api_name);
7647: END IF;
7648:

Line 7645: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

7641: ROLLBACK TO Duplicate_Cart;
7642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7643:
7644: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7645: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
7646: l_api_name);
7647: END IF;
7648:
7649: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

7645: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
7646: l_api_name);
7647: END IF;
7648:
7649: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
7650: p_count => x_msg_count,
7651: p_data => x_msg_data);
7652:
7653:

Line 7731: FND_Msg_Pub.initialize;

7727: END IF;
7728:
7729: -- Initialize message list if p_init_msg_list is set to TRUE.
7730: IF FND_API.To_Boolean(p_init_msg_list) THEN
7731: FND_Msg_Pub.initialize;
7732: END IF;
7733: -- Initialize API return status to success
7734: x_return_status := FND_API.G_RET_STS_SUCCESS;
7735:

Line 7773: FND_MSG_PUB.Add;

7769: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
7770: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
7771: FND_MESSAGE.Set_Token('ERRNO', 'IB_INSTANCE_LOCKED');
7772: FND_MESSAGE.Set_Token('REASON','This instance is locked cannot reconfigure');
7773: FND_MSG_PUB.Add;
7774: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7775: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
7776: END IF;
7777: RAISE FND_API.G_EXC_ERROR;

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

7770: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
7771: FND_MESSAGE.Set_Token('ERRNO', 'IB_INSTANCE_LOCKED');
7772: FND_MESSAGE.Set_Token('REASON','This instance is locked cannot reconfigure');
7773: FND_MSG_PUB.Add;
7774: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7775: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
7776: END IF;
7777: RAISE FND_API.G_EXC_ERROR;
7778: END IF;

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

7771: FND_MESSAGE.Set_Token('ERRNO', 'IB_INSTANCE_LOCKED');
7772: FND_MESSAGE.Set_Token('REASON','This instance is locked cannot reconfigure');
7773: FND_MSG_PUB.Add;
7774: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7775: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
7776: END IF;
7777: RAISE FND_API.G_EXC_ERROR;
7778: END IF;
7779: END LOOP;

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

7882: COMMIT WORK;
7883: END IF;
7884:
7885: -- Standard call to get message count and if count is 1, get message info.
7886: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
7887: p_count => x_msg_count ,
7888: p_data => x_msg_data);
7889: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
7890: IBE_Util.Debug('End IBE_Quote_Save_pvt.Reconfigure_from_ib() end');

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

7892: EXCEPTION
7893: WHEN FND_API.G_EXC_ERROR THEN
7894: ROLLBACK TO Reconfigure_From_Ib;
7895: x_return_status := FND_API.G_RET_STS_ERROR;
7896: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
7897: p_count => x_msg_count,
7898: p_data => x_msg_data);
7899:
7900: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

7899:
7900: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7901: ROLLBACK TO Reconfigure_From_Ib;
7902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7903: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
7904: p_count => x_msg_count,
7905: p_data => x_msg_data);
7906:
7907: WHEN OTHERS THEN

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

7907: WHEN OTHERS THEN
7908: ROLLBACK TO Reconfigure_From_Ib;
7909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7910:
7911: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7912: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
7913: l_api_name);
7914: END IF;
7915:

Line 7912: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

7908: ROLLBACK TO Reconfigure_From_Ib;
7909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7910:
7911: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7912: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
7913: l_api_name);
7914: END IF;
7915:
7916: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

7912: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
7913: l_api_name);
7914: END IF;
7915:
7916: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
7917: p_count => x_msg_count,
7918: p_data => x_msg_data);
7919:
7920: END RECONFIGURE_FROM_IB;

Line 8124: FND_MSG_PUB.initialize;

8120: END IF;
8121:
8122: -- Initialize message list if p_init_msg_list is set to TRUE.
8123: IF FND_API.to_Boolean(p_init_msg_list) THEN
8124: FND_MSG_PUB.initialize;
8125: END IF;
8126:
8127: -- Initialize API return status to success.
8128: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 8167: FND_MSG_PUB.Add;

8163: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
8164: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
8165: FND_MESSAGE.Set_Token('ERRNO', 'IBE_ST_INVALID_OPERATION');
8166: FND_MESSAGE.Set_Token('REASON', 'quote header id is null');
8167: FND_MSG_PUB.Add;
8168: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8169: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
8170: END IF;
8171: RAISE FND_API.G_EXC_ERROR;

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

8164: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
8165: FND_MESSAGE.Set_Token('ERRNO', 'IBE_ST_INVALID_OPERATION');
8166: FND_MESSAGE.Set_Token('REASON', 'quote header id is null');
8167: FND_MSG_PUB.Add;
8168: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8169: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
8170: END IF;
8171: RAISE FND_API.G_EXC_ERROR;
8172: END IF;

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

8165: FND_MESSAGE.Set_Token('ERRNO', 'IBE_ST_INVALID_OPERATION');
8166: FND_MESSAGE.Set_Token('REASON', 'quote header id is null');
8167: FND_MSG_PUB.Add;
8168: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8169: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
8170: END IF;
8171: RAISE FND_API.G_EXC_ERROR;
8172: END IF;
8173:

Line 8191: FND_MSG_PUB.Add;

8187: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
8188: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
8189: FND_MESSAGE.Set_Token('ERRNO', 'IBE_ST_INVALID_OPERATION');
8190: FND_MESSAGE.Set_Token('REASON', 'size of line records does not match size of line quantities');
8191: FND_MSG_PUB.Add;
8192: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8193: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
8194: END IF;
8195: RAISE FND_API.G_EXC_ERROR;

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

8188: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
8189: FND_MESSAGE.Set_Token('ERRNO', 'IBE_ST_INVALID_OPERATION');
8190: FND_MESSAGE.Set_Token('REASON', 'size of line records does not match size of line quantities');
8191: FND_MSG_PUB.Add;
8192: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8193: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
8194: END IF;
8195: RAISE FND_API.G_EXC_ERROR;
8196: END IF;

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

8189: FND_MESSAGE.Set_Token('ERRNO', 'IBE_ST_INVALID_OPERATION');
8190: FND_MESSAGE.Set_Token('REASON', 'size of line records does not match size of line quantities');
8191: FND_MSG_PUB.Add;
8192: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8193: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
8194: END IF;
8195: RAISE FND_API.G_EXC_ERROR;
8196: END IF;
8197:

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

8564: EXCEPTION
8565: WHEN FND_API.G_EXC_ERROR THEN
8566: ROLLBACK TO UPDATE_SUPPORT_LEVEL_AND_QTY;
8567: x_return_status := FND_API.G_RET_STS_ERROR;
8568: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
8569: p_count => x_msg_count,
8570: p_data => x_msg_data);
8571:
8572: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

8571:
8572: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8573: ROLLBACK TO UPDATE_SUPPORT_LEVEL_AND_QTY;
8574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8575: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
8576: p_count => x_msg_count,
8577: p_data => x_msg_data);
8578:
8579: WHEN OTHERS THEN

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

8578:
8579: WHEN OTHERS THEN
8580: ROLLBACK TO UPDATE_SUPPORT_LEVEL_AND_QTY;
8581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8582: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8583: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
8584: END IF;
8585: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
8586: p_count => x_msg_count,

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

8579: WHEN OTHERS THEN
8580: ROLLBACK TO UPDATE_SUPPORT_LEVEL_AND_QTY;
8581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8582: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8583: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
8584: END IF;
8585: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
8586: p_count => x_msg_count,
8587: p_data => x_msg_data);

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

8581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8582: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8583: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
8584: END IF;
8585: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
8586: p_count => x_msg_count,
8587: p_data => x_msg_data);
8588: END UPDATE_SUPPORT_AND_QUANTITY;
8589: